Oracle Error Messages

PLS-01903: : non-integer error number

PLS-01903: : non-integer error number

Cause: SQLERRM() was called with a non-integer value.

Action: Make sure SQLERRM() is called with an integer value.

PLS-01902: : hex to raw conversion error

PLS-01902: : hex to raw conversion error

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

Action: Verify that the hexadecimal variable to be converted contains a valid hexadecimal value.

PLS-01901: : host bind array too small

PLS-01901: : host bind array too small

Cause: PL or SQL was unable to transfer data into a host array because the array is too small.

Action: Increase the size of the host array.

PLS-01900: : character to number conversion error

PLS-01900: : character to number conversion error

Cause: There was a failure while converting a character string into a numeric value.

Action: Verify that all character strings assigned to number variables have valid numeric value interpretations.

PLS-01714: ANSI expects a column name not a literal value here

PLS-01714: ANSI expects a column name not a literal value here

Cause: ANSI expects a column name not a literal value here

Action: none

PLS-01713: The constraints on these types do not match

PLS-01713: The constraints on these types do not match

Cause: The constraints on these types do not match

Action: none

PLS-01712: ANSI does not allow bind variables as INDICATORS

PLS-01712: ANSI does not allow bind variables as INDICATORS

Cause: ANSI does not allow bind variables as INDICATORS

Action: none

PLS-01711: A SELECT statement may not contain ORDER_BY, HAVING, or GROUP_BY clause

PLS-01711: A SELECT statement may not contain ORDER_BY, HAVING, or GROUP_BY clause

Cause: A SELECT statement may not contain ORDER_BY, HAVING, or GROUP_ BY clause. Sect. 8.10.

Action: none

PLS-01710: In a positioned DELETE or UPDATE statement, the cursor name must be of length 1

PLS-01710: In a positioned DELETE or UPDATE statement, the cursor name must be of length 1

Cause: In a positioned DELETE or UPDATE statement, the cursor name must be of length 1.

Action: none

PLS-01709: value list of INSERT statement, if specified with value list rather than subquery, must be value specification

PLS-01709: value list of INSERT statement, if specified with value list rather than subquery, must be value specification

Cause: In an INSERT statement, the insert value list, if specified with a value list rather than a subquery, must be value specifications, i.e. no compound expressions or column references. Sect 8.7.

Action: none

PLS-01708: In searched DELETE, UPDATE or INSERT, table must not appear in FROM clause of subqueries in search condition

PLS-01708: In searched DELETE, UPDATE or INSERT, table must not appear in FROM clause of subqueries in search condition

Cause: In a searched DELETE, UPDATE or INSERT statement, the table affected must not appear in a FROM clause in any of the subqueries in the search condition.

Action: none

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

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 fromor updated must be identified in the specifictation of the cursor.

Action: none

PLS-01705: table specified by a cursor not updatable if cursor specification has a UNION or ORDER_BY

PLS-01705: table specified by a cursor not updatable if cursor specification has a UNION or ORDER_BY

Cause: Missing keyword FROM.

Action: none

PLS-01704: The expressions in a sort clause must be column specs or unsigned integers, with optional ASC or DESC

PLS-01704: The expressions in a sort clause must be column specs or unsigned integers, with optional ASC or DESC

Cause: The expressions in a sort clause may only be column specifications or unsigned integers, followed by optional ASC or DESC.

Action: none