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-15018: diskgroup cannot be created

1 Answers  


LSX-00147: "~1S" cannot contain "~2S"

1 Answers  


ORA-01516: nonexistent log file, datafile, or tempfile "string"

1 Answers  


DRG-11847: Revalidation Failed

1 Answers  


ORA-19629: no files in specified archivelog SCN range

1 Answers  






ORA-30043: Invalid value 'string' specified for parameter 'Undo_Management'

1 Answers  


EXP-00049: %s option is not compatible with Point-in-time Recovery or Transportable Tablespace Export

1 Answers  


DRG-52104: the Oracle Text environment could not initialize

1 Answers  


ORA-31431: all source tables must belong to the synchronous change set

1 Answers  


AMD-00104: Level "string" cannot be added to the hierarchy; parent and child parameters represent the same level

1 Answers  


RMAN-10024: error setting up for rpc polling

1 Answers  


ORA-25180: PCTTHRESHOLD only valid for certain table organizations

1 Answers  


Categories