In this post, you’ll learn more about the Oracle ErrorPLS-00314: TABLE declarations are not allowed as PL/SQL local variables with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
PLS-00314: TABLE declarations are not allowed as PL/SQL local variables
Reason for the Error PLS-00314: TABLE declarations are not allowed as PL/SQL local variables
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.
How to fix the Error PLS-00314: TABLE declarations are not allowed as PL/SQL local variables ?
You can fix this error in Oracle by following the below steps
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.