The following is the SQL-02156 error message, you can learn the cause and solution of the Oracle SQL error.

SQL-02156: Invalid type for Indicator or Returned Length

Cause: A host variable associated with the item Indicator or Returned Length must be of type short or s9(4) comp. If value semantics and scalar they may also be gotten into display sign leading separate host variables

Solution: Use signed short for indicator, ref indicator and returned length, ref returned length host variables in C. For COBOL use s9(4) comp. for GETs only with non-arrays and you may use display sign leading separate host variables

Case:

Please wait for the update…