PLS Error Codes

ANSI does not accept SAVEPOINTs

: character to number conversion error

: host bind array too small

Illegal syntax in ROLLBACK WORK statement

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