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-04007: MINVALUE cannot be made to exceed the current value
ORA-13630: The task string contains execution results and cannot be executed.
ORA-29875: failed in the execution of the ODCIINDEXINSERT routine
ORA-32153: Environment not specified
DRG-11500: column name expected, found string on line string
LFI-00125: Random access only allowed on fixed length record files.
ORA-01282: date range specified is invalid
DGM-16992: You must shut down instance "string" manually.
DRG-50000: requested size larger than pagesize
RMAN-11001: Oracle Error: string
ORA-01526: error in opening file 'string'
RMAN-05005: point-in-time recovery is not allowed for re-created tablespace string