Category Archives: PLS Database Error Messages

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

oracle

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, that is, no compound expressions or column references.
Action: Refer to ANSI document ANSI X3.135-1992 for details.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

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

oracle

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

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

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

oracle

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

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

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

oracle

PLS-01705: table specified by a cursor not updatable if cursor specification has a UNION or ORDER_BY
Cause: The table specified by a cursor is not updatable if the cursor specification contains a UNION or ORDER_BY.
Action: Refer to ANSI document ANSI X3.135-1992 for details.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

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

oracle

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

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-01703: Cursor name in CLOSE statment must be of length 1

oracle

PLS-01703: Cursor name in CLOSE statment must be of length 1
Cause: Cursor name in CLOSE statement 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/

PLS-01702: Illegal syntax in COMMIT WORK statement

oracle

PLS-01702: Illegal syntax in COMMIT WORK statement
Cause: Illegal syntax in COMMIT WORK statement.
Action: Refer to ANSI document ANSI X3.135-1992 for details.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-01701: Illegal syntax in ROLLBACK WORK statement

oracle

PLS-01701: Illegal syntax in ROLLBACK WORK statement
Cause: Illegal syntax in ROLLBACK WORK statement.
Action: Refer to ANSI document ANSI X3.135-1992 for details.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-01507: DROP is non-ANSI

oracle

PLS-01507: DROP is non-ANSI
Cause: DROP is non-ANSI.
Action: Refer to ANSI document ANSI X3.135-1992 for details.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-01506: CREATE INDEX is non-ANSI

oracle

PLS-01506: CREATE INDEX is non-ANSI
Cause: CREATE INDEX is non-ANSI.
Action: Refer to ANSI document ANSI X3.135-1992 for details.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/