How to fix the Oracle error PCB-00600: indicators are not allowed in EXEC IAF statements?

In this post, you’ll learn more about the Oracle ErrorPCB-00600: indicators are not allowed in EXEC IAF statements with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PCB-00600: indicators are not allowed in EXEC IAF statements

Reason for the Error PCB-00600: indicators are not allowed in EXEC IAF statements

Cause: Indicator variables associated with host variables cannot be used in EXEC IAF statements such as GET and PUT in a user exit.

How to fix the Error PCB-00600: indicators are not allowed in EXEC IAF statements ?

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

Action: Eliminate the indicator variables. If feasible (for example with Forms V4), use EXEC TOOLS statements, which do allow indicator variables. See the Programmer’s Guide to the Oracle Precompilers for more information of EXEC IAF and EXEC TOOLS statements.