In this post, you’ll learn more about the Oracle ErrorPGU-42017: VALUES can be used only at level 88 with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
PGU-42017: VALUES can be used only at level 88
Reason for the Error PGU-42017: VALUES can be used only at level 88
Cause: The VALUES keyword can only be specified in a data definition describing a condition and only at level 88.
How to fix the Error PGU-42017: VALUES can be used only at level 88 ?
You can fix this error in Oracle by following the below steps
Action: If the defintion describes a condition, make sure it is at level 88; if the definition does not describe a condition, then use VALUE IS rather than VALUES ARE.