PLS Error Codes

ANSI expects a column name not a literal value here

ANSI does not accept SAVEPOINTs

: character to number conversion error

Constraint name and constraint status are non-ANSI.

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

The expression in a SET clause must not include a set function

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

Use of AS phase in CREATE TABLE statement is non_ANSI

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

ALTER is non-ANSI