How to fix the Oracle error PLS-00309: with %LAST attribute, ‘string’ must be a variable of an enumerated type?

In this post, you’ll learn more about the Oracle ErrorPLS-00309: with %LAST attribute, ‘string’ must be a variable of an enumerated type with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PLS-00309: with %LAST attribute, ‘string’ must be a variable of an enumerated type

Reason for the Error PLS-00309: with %LAST attribute, ‘string’ must be a variable of an enumerated type

The “%LAST” attribute must be applied to an identifier that has been declared as a variable of an enumerated type (or subtype of an enumerated type). This error occurs when “%LAST” follows some identifier that has not been so declared.

How to fix the Error PLS-00309: with %LAST attribute, ‘string’ must be a variable of an enumerated type ?

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

None