PLS Error Codes

Pragma string must be declared in a package specification

Pragma string must be declared in package specification and body

PRAGMA AUTONOMOUS_TRANS*Action cannot be declared here

PRAGMA AUTONOMOUS_TRANS*Action cannot be declared twice

Local collection types not allowed in SQL statements

Booleans- index tables- records and cursors not allowed in SQL statements

Character set mismatch found at ‘string’ among result expressions in a CASE expression

Character set mismatch found at ‘string’ among operands in a COALESCE expression

Pipelined functions must have a collection return type

PARTITION-BY and CLUSTER/ORDER-BY clauses must be used with the same function argument