Question: I am
getting this PLS-00310 error in my PL/SQL:
-- PLS-00310 - [Error] PLS-00310 (9:
33): PLS-00310: with %ROWTYPE attribute, 'P_TBL_NAME' must
name a table, cursor or cursor-variable
-- [Error] PLS-00597 (26: 52):
PLS-00597: expression 'L_DATA' in the INTO list is of wrong
type
--
[Error] ORA-00904 (29: 51): PL/SQL: ORA-00904: : invalid
identifier
How do I correct the PLS-00310
error?
Answer:
Here are the oerr notes on the PLS-00310 error:
Error: PLS-00310
PLS-00310
description: With %%ROWTYPE attribute, "string"
must name a table, cursor or cursor-variable
PLS-00310 Cause: The %ROWTYPE attribute
must be applied to an identifier declared as a cursor,
cursor variable, or database table.
This error occurs when %ROWTYPE follows some identifier that
has not been so declared.
Action: Change the declaration or do not
apply the %ROWTYPE attribute to the identifier.
