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-01267: Failure getting date/time
ORA-24161: name string does not exist in the name value pair list
SQL*Loader-00916: Error checking path homogeneity
PLS-00339: "string" matches object-table without a REF or VALUE modifier
ORA-27451: %s cannot be NULL
ORA-37075: (XSMCSESS03) You cannot rename a session-only dimension value.
ORA-26708: remote DDL not supported by STREAMS : dblink string
ORA-02831: Segment deallocation failed - empty segment list
ORA-14025: PARTITION may not be specified for a materialized view or a materialized view log
ORA-09927: Unable to set label of server
RMAN-06067: RECOVER DATABASE required with a backup or created controlfile
ORA-19680: some blocks not recovered. See trace file for details