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-08440: raw buffer is too short to hold converted data
ORA-14173: illegal subpartition-extended table name syntax
ORA-07488: scgrcl: lock manager not initialized.
ORA-36610: (XSLMS00) Unable to locate a message file for product 'value' and facility 'value'.
ORA-13152: invalid HHCODE type
ORA-36871: (XSFTDSC01) Object string cannot be used to define a column in a LIMITMAP.
RMAN-06904: backup of log thread number seq number lowscn string was cancelled
NNL-00540: [show] status [<server_list>] : display server status summary
ORA-01982: invalid auditing option for tables
KUP-04017: OS message: string
ORA-29341: The transportable set is not self-contained
ORA-33445: (ESDREAD15) Discarding compiled code for workspace object because workspace object and workspace object, which were not partition-dependent when the code was compiled, are now partition-dependent.