How to fix the Oracle error SQL-02124: NULL value returned by EXEC TOOLS statement?

In this post, you’ll learn more about the Oracle ErrorSQL-02124: NULL value returned by EXEC TOOLS statement with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

SQL-02124: NULL value returned by EXEC TOOLS statement

Reason for the Error SQL-02124: NULL value returned by EXEC TOOLS statement

Cause: A NULL value was returned by EXEC TOOLS for a host variable that lacks an indicator variable. This error is returned only when MODE=ANSI. When MODE=ORACLE, although the value of the host variable is indeterminate, no error is generated.

How to fix the Error SQL-02124: NULL value returned by EXEC TOOLS statement ?

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

Action: Associate an indicator variable with each host variable to which nulls might be returned.