SQL-02156: Invalid type for Indicator or Returned Length
- 1 Answers
- 2043 Views
- I also Faced
- E-Mail Answers
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 |
ORA-16607: one or more databases have failed
ORA-06407: NETCMN: unable to set up break handling environment
ORA-00991: only MAC privileges may be granted to procedures
ORA-27100: shared memory realm already exists
ORA-30395: dimension options require the COMPATIBLE parameter to be string or greater
ORA-16742: The standby "string" has used up its quota.
RMAN-06186: PL/SQL package string.string version string in string database is too old
ORA-26690: datatype not supported at non-Oracle system
ORA-23460: missing value for column string in resolution method "string" for "string"."string"."string"
ORA-07406: slbtpd: invalid number.
DRG-50928: reserved failure on line string on column string
ORA-00108: failed to set up dispatcher to accept connection asynchronously
Oracle Errors 
