Oracle Error PLS-00206: %TYPE must be applied to a variable, column, field or attribute, not to “string”

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).