Database Error Messages

PLS-00314

TABLE declarations are not allowed as PL/SQL local variables

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.