PLS Error Codes

Illegal syntax in COMMIT WORK statement

Cursor name in CLOSE statment must be of length 1

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

Table specified by a cursor not updatable if cursor specification has a UNION or ORDER_BY

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

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

Value list of INSERT statement- if specified with value list rather than subquery- must be value specification

Unions are not allowed in the definition of a view

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

Options in CREATE TABLE statement is non-ANSI.