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-07617: $FORMAT_CLASS failed translating the binary label to a string

1 Answers  


ORA-30117: syntax error at 'string' at the start of input

1 Answers  


ORA-25008: no implicit conversion to LOB datatype in instead-of trigger

1 Answers  


ORA-13023: interior element interacts with exterior element

1 Answers  


ORA-21701: attempt to flush objects to different servers

1 Answers  






ORA-01880: the fractional seconds must be between 0 and 999999999

1 Answers  


ORA-01689: syntax error in clause "string" of string

1 Answers  


ORA-39115: %s is not supported over a network link

1 Answers  


ORA-14326: Primary index on an IOT, DOMAIN and LOB indexes may not be specified in the UPDATE INDEXES clause

1 Answers  


ORA-13443: GeoRaster metadata SRS error

1 Answers  


ORA-16527: unable to allocate SGA heap

1 Answers  


QSM-02014: GROUP BY expression other than a column

1 Answers  


Categories