Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

ORA-07616: $CHANGE_CLASS failed in retrieving the specified device label

1 Answers  


ORA-01048: Couldn't find the specified procedure in the given context

1 Answers  


ORA-38412: Expression set column string does not exist.

1 Answers  


DRG-12607: only ctxsys can create MULTI_COLUMN preferences

1 Answers  


ORA-00130: invalid listener address 'string'

2 Answers  






RMAN-06135: error executing host command: string

1 Answers  


RMAN-06534: KEEP ... CONSISTENT option is not supported

1 Answers  


ORA-02169: FREELISTS storage option not allowed

1 Answers  


TNS-12686: Invalid command specified for a service

1 Answers  


LPX-00285: invalid Unicode surrogate ~X ~X

1 Answers  


ORA-22992: cannot use LOB locators selected from remote tables

1 Answers  


NZE-29029: SSL handshake already completed

1 Answers  






Categories