Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

NID-00603: No datafiles found in database

1 Answers  


ORA-30019: Illegal rollback Segment operation in Automatic Undo mode

1 Answers  


QSM-01089: an inline view in the query does not have a materialized view

1 Answers  


RMAN-06102: no channel to restore a backup or copy of log thread number seq number lowscn string

1 Answers  


ORA-14457: disallowed Nested Table column in a Temporary table

1 Answers  






QSM-00508: statistics missing on tables/columns

1 Answers  


ORA-17505: ksfdrsz:string Failed to resize file to size string blocks

1 Answers  


ORA-23413: table "string"."string" does not have a materialized view log

1 Answers  


ORA-32013: failure in verifying parameters from the restored SPFILE

1 Answers  


ORA-06954: Illegal file name

1 Answers  


DRG-11512: bad syntax for thesaurus load file at line string

1 Answers  


PROC-00105: Logging error

1 Answers  






Categories