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-27414: Invalid BY value type
ORA-06562: type of out argument must match type of column or bind variable
ORA-26077: direct path column array is not initialized
DRG-11865: News Server Replies
ORA-30104: 'string' is not a legal integer for 'string'
ORA-14126: only a <parallel clause> may follow description(s) of resulting partitions
ORA-22627: tc [string] must be that of object/varray/nested table
ORA-32320: REFRESH FAST of "string"."string" unsupported after container table PMOPs
ORA-32639: Aggregate functions on reference MODELs are not allowed
ORA-12924: tablespace string is already in force logging mode
ORA-13773: insufficient privileges to select data from the cursor cache
ORA-09215: sfqio: error detected in IOCompletionRoutine