Oracle Error Message
PLS-00206: %TYPE must be applied to a variable, column, field or attribute, not to “string”
Reason for the Error
The program object declared using the %TYPE datatype attribute is not of the appropriate class. It must be a variable, column, record component, subprogram formal parameter, or other object to which values can be assigned.
Solution
Declare an object of the appropriate class or define the datatype in another way (for example, use %ROWTYPE).