Error List

Error List for the ‘ORADB-PLS’ Category

PLS-00992 Cursor Variables cannot be FETCH'ed from

Description:
PLS-00992 Cursor Variables cannot be FETCH’ed from

Cause:
An attempt was made to perform a FETCH from a cursor variable.

ORADB-PLS

PLS-01451 The data types of these value_expressions must be comparable

Description:
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.

ORADB-PLS

PLS-01707 In positioned DELETE or UPDATE statement, table must be identified in specification of cursor

Description:
PLS-01707 In positioned DELETE or UPDATE statement, table must be identified in specification of cursor

Cause:
In a positioned DELETE or UPDATE statement, the table deleted from or updated must be identified in the specification of the cursor.

ORADB-PLS

PLS-01405 Under ANSI's grammar, numeric data represented in exponent notationmust use an uppercase E

Description:
PLS-01405 Under ANSI’s grammar, numeric data represented in exponent notationmust use an uppercase E

Cause:
Under ANSI’s grammar, numeric data represented in exponent notation must use an uppercase “E”. Example: 3.45E-6 is ANSI, but 3.45e-6 is not.

ORADB-PLS

PLS-01467 The value list of the IN predicate, if not a subquery, must contain only value_specifications

Description:
PLS-01467 The value list of the IN predicate, if not a subquery, must contain only value_specifications

Cause:
The value list of the IN predicate, if not a subquery, must contain only value_specifications (that is, literals and PL/SQL or embedded variables).

ORADB-PLS

PLS-01902 : hex to raw conversion error

Description:
PLS-01902 : hex to raw conversion error

Cause:
There was a failure while converting a hexadecimal string to a raw.

ORADB-PLS , , , , ,

PLS-01416 Use of id (value...) here

Description:
PLS-01416 Use of id (value…) here

Cause:
Use of id (value…) here is not in ANSI’s grammar.

ORADB-PLS

PLS-01503 The expression in a SET clause must not include a set function

Description:
PLS-01503 The expression in a SET clause must not include a set function

Cause:
The expression in a SET clause must not include a set function.

ORADB-PLS

PLS-00993 Cursor Variables cannot be passed as RPC arguments or results

Description:
PLS-00993 Cursor Variables cannot be passed as RPC arguments or results

Cause:
An attempt was made to pass a cursor variable to or from a remote subprogram, which is not allowed. For example, a remote procedure cannot be used to open a cursor variable because remote subprograms cannot return the values of cursor variables.

ORADB-PLS , , , ,

PLS-01452 This function is not part of the ANSI standard

Description:
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.

ORADB-PLS