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-02329: column of datatype string cannot be unique or a primary key
ORA-29741: IMR active for some, but not all members of cluster
TNS-12554: TNS:current operation is still in progress
QSM-01006: query rewrite disabled for this query block
ORA-16101: a valid start SCN could not be found
ORA-19830: error from target database: string
DRG-13100: index is not partitioned
NNL-00990: DEFAULT-FORWARDERS-ONLY mode: string
ORA-25287: Invalid value string, string should be non-negative
ORA-12005: may not schedule automatic refresh for times in the past
ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine
NNL-00266: Round trip time is string