How to fix the Oracle error PLS-00206: %TYPE must be applied to a variable, column, field or attribute, not to “string”?

In this post, you’ll learn more about the Oracle ErrorPLS-00206: %TYPE must be applied to a variable, column, field or attribute, not to “string” with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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.

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

You can fix this error in Oracle by following the below steps

Declare an object of the appropriate class or define the datatype in another way (for example, use %ROWTYPE).