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

In this post, you’ll learn more about the Oracle ErrorPCC-02348: 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

PCC-02348: indicators are not allowed in EXEC IAF statements

Reason for the Error PCC-02348: indicators are not allowed in EXEC IAF statements

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

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

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

Action: Eliminate the indicator variabls. 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 EXECIAF and EXEC TOOLS statements.