SQL-02156: Invalid type for Indicator or Returned Length



SQL-02156: Invalid type for Indicator or Returned Length..

Answer / guest

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

Action: 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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

LPX-00223: external entity "~s" found in an attribute value

1 Answers  


ORA-06535: statement string in string is NULL or 0 length

1 Answers   RoboSoft,


NZE-29105: Cannot export PKCS #12 wallet.

1 Answers  


ORA-12527: TNS:listener: all instances are in restricted mode or blocking new connections

1 Answers  


PLS-00730: collection element type does not allow modifications

1 Answers  






PLS-00308: this construct is not allowed as the origin of an assignment

1 Answers  


TNS-12502: TNS:listener received no CONNECT_DATA from client

1 Answers  


PCB-00401: Character string not properly terminated

1 Answers  


ORA-15121: ASM file name 'string' contains an invalid diskgroup name

1 Answers  


PLS-00718: type of attribute 'string' does not allow modifications to the attribute

1 Answers  


ORA-28274: No ORACLE password attribute corresponding to user nickname exists.

1 Answers  


SQL*Loader-00115: Invalid direct path option

1 Answers  


Categories