PLS-00314: TABLE declarations are not allowed as PL/SQL
local variables



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

Post New Answer

More Oracle Errors Interview Questions

ORA-38495: data type for the stored attribute string is inconsistent.

1 Answers  


ORA-31028: Resource metadata length string exceeded maximum length string

1 Answers  


SQL*Loader-00530: OCI return status: need data

1 Answers  


RMAN-10012: KGU error: string

1 Answers  


PCB-00639: Cannot specify destination offset in a LOB WRITE APPEND

1 Answers  






ORA-39061: import mode string conflicts with export mode string

1 Answers  


SQL*Loader-00432: converted data too large

1 Answers  


LSX-00016: schema and instance document have incompatible character sets

1 Answers  


TNS-00532: No previous async operation to wait on

1 Answers  


PLS-00305: previous use of 'string' (at line string) conflicts with this use

1 Answers  


ORA-01866: the datetime class is invalid

3 Answers  


LPX-00246: missing system ID after public ID

1 Answers  


Categories