How to fix the Oracle error PCC-00075: “:” expected before indicator variable?

In this post, you’ll learn more about the Oracle ErrorPCC-00075: “:” expected before indicator variable with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PCC-00075: “:” expected before indicator variable

Reason for the Error PCC-00075: “:” expected before indicator variable

Cause: An indicator variable was not prefixed with a colon, as required.

How to fix the Error PCC-00075: “:” expected before indicator variable ?

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

Action: Prefix a colon to the indicator variable in question.