PLS-00314: TABLE declarations are not allowed as PL/SQL
local variables
Answer / guest
Cause: In a precompiled program, the DECLARE TABLE statement
was mistakenly used inside an embedded PL/SQL block. If an
embedded PL/SQL block refers to a database table that does
not yet exist, use the DECLARE TABLE statement to tell the
precompiler what the table will look like. However, DECLARE
TABLE statements are allowed only in the host program.
Action: Move the DECLARE TABLE statement outside the
embedded PL/SQL block. If you want a variable that can store
an entire row of data selected from a database table or
fetched from a cursor or cursor variable, use the %ROWTYPE
attribute.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-25295: Subscriber is not allowed to dequeue buffered messages
PLS-01713: The constraints on these types do not match
ORA-04072: invalid trigger type
PCB-00701: MAX OCCURRANCES must be between 1 and 65535
ORA-24003: Queue table index string inconsistent with queue table string
ORA-26007: invalid value for SETID or OID column
PCB-00214: JUSTIFIED clause not allowed for host variable "string"
DRG-11121: failed to read from file string
ORA-13450: GeoRaster metadata layerInfo error
PLS-00397: Type mismatch in arguments to IN
PCC-00021: Oracle Error: string
IMG-00580: specified format does not support output