Category Archives: PLS Database Error Messages

PLS-01903: non-integer error number

oracle

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.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-01902: hex to raw conversion error

oracle

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.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-01901: host bind array too small

oracle

PLS-01901: host bind array too small
Cause: PL/SQL was unable to transfer data into a host array because the array is too small.
Action: Increase the size of the host array.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-01900: character to number conversion error

oracle

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.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-01715: ANSI does not accept SAVEPOINTs

oracle

PLS-01715: ANSI does not accept SAVEPOINTs
Cause: ANSI does not accept SAVEPOINTs.
Action: Refer to ANSI document ANSI X3.135-1992 for details.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

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

oracle

PLS-01714: ANSI expects a column name not a literal value here 
Cause: ANSI expects a column name not a literal value here.
Action: Refer to ANSI document ANSI X3.135-1992 for details.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

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

oracle

PLS-01713: The constraints on these types do not match
Cause: The constraints on these types do not match.
Action: Refer to ANSI document ANSI X3.135-1992 for details.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

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

oracle

PLS-01712: ANSI does not allow bind variables as INDICATORS
Cause: ANSI does not allow bind variables as INDICATORS.
Action: Refer to ANSI document ANSI X3.135-1992 for details.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

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

oracle

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.
Action: Refer to ANSI document ANSI X3.135-1992 for details.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

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

oracle

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: Refer to ANSI document ANSI X3.135-1992 for details.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/