PLS-01458: The set clause in an UPDATE statement requires a column name of length 1
Cause: The set clause in an UPDATE statement requires a column name of length 1.
Action: Refer to ANSI document ANSI X3.135-1992 for details.
All posts by mpbod
PLS-01456: Name length cannot exceed 3
PLS-01456: Name length cannot exceed 3
Cause: Name length cannot exceed 3.
Action: Refer to ANSI document ANSI X3.135-1992 for details.
PLS-01455: The predicates IS NULL and IS NOT NULL are defined only for column specifications
PLS-01455: The predicates IS NULL and IS NOT NULL are defined only for column specifications
Cause: The predicates "IS NULL" and "IS NOT NULL" are defined only for column specifications, not for any other expressions. Section 5.15, "null_predicate", indicates that in the predicate "x IS NULL", x must be a column, and may not be any other kind of expression.
Action: Refer to ANSI document ANSI X3.135-1992 for details.
PLS-01454: No operator may be used with values of data type CHAR
PLS-01454: No operator may be used with values of data type CHAR
Cause: No operator may be used with values of data type "character string". Section 5.9, "value_expression", syntax rule 3, of X3H2 states: "If the data type of a primary is character string, then the value_expression shall not include any operators." This warning is placed on many functions in STDBASE that take CHAR arguments.
Action: Refer to ANSI document ANSI X3.135-1992 for details.
PLS-01453: This procedure is not part of the ANSI standard
PLS-01453: This procedure is not part of the ANSI standard
Cause: This procedure is not part of the ANSI standard. This warning is used to flag such procedures as "STOP" that are not mentioned in the ANSI specifications.
Action: Refer to ANSI document ANSI X3.135-1992 for details.
PLS-01452: This function is not part of the ANSI standard
PLS-01452: This function is not part of the ANSI standard
Cause: This function is not part of the ANSI standard. This warning is used to flag such functions as "POWER" that are not mentioned in the ANSI specifications.
Action: Refer to ANSI document ANSI X3.135-1992 for details.
PLS-01451: The data types of these value_expressions must be comparable
PLS-01451: The data types of these value_expressions must be comparable
Cause: The data types of these value_expressions must be comparable. Section 4.2 of X3H2, "Data types", states that: "A character string and a number are not comparable values." Many built-in functions in STANDARD will be flagged with this warning by means of a pragma. This warning will be place on data-type coercion functions, for example, TO_CHAR(number), that are inserted in Oracle SQL to allow non-conforming data type combinations.
Action: Refer to ANSI document ANSI X3.135-1992 for details.
PLS-01450: This value_expression contains a nonconforming data type
PLS-01450: This value_expression contains a nonconforming data type
Cause: This value_expression contains a nonconforming data type. Section 4.2 of X3H2, "Data types" states that: "A non-null value is either a character string or a number." Many built-in functions in STANDARD will be flagged with this warning by means of a pragma.
Action: Refer to ANSI document ANSI X3.135-1992 for details.
PLS-01425: Connect-by clause
PLS-01425: Connect-by clause
Cause: ANSI does not allow connect-by clauses.
Action: Refer to ANSI document ANSI X3.135-1992 for details.
PLS-01424: Non-ANSI order of clauses
PLS-01424: Non-ANSI order of clauses
Cause: ANSI specifies an ordering to clauses in a table-expression which PL/SQL does not. The ordering according to ANSI must be: from clause where clause group-by clause having clause In PL/SQL, the from clause must come first, and the clauses after it can appear in any order (with the addition of the non-ANSI connect-by clause).
Action: Refer to ANSI document ANSI X3.135-1992 for details.