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


SQL-02152: Invalid numeric variable for use in an array
GET/SET statement



SQL-02152: Invalid numeric variable for use in an array GET/SET statement..

Answer / guest

Cause: An host variable with type other than int or short
for C or S9(4) or S9(9) binary or comp was used for an exact
numeric with and array size > 1.

Action: Use only int or short for C or S9(4) or S(9) binary
or comp for COBOL when supplying an exact numeric in
conjunction with the for clause to indicate arrays.
Specifically, display sign leading separate is not allowed
in this context.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02203: INITIAL storage options not allowed

1 Answers  


ORA-30006: resource busy; acquire with WAIT timeout expired

1 Answers  


DRG-11820: Unauthorized

1 Answers  


ORA-02344: cannot revoke execute on a type with table dependents

1 Answers  


ORA-01804: failure to initialize timezone information

2 Answers  






ORA-30191: missing argument list

1 Answers  


NNL-00899: OK responses sent: number

1 Answers  


ORA-23416: table "string"."string" does not contain a primary key constraint

1 Answers  


ORA-36930: Cannot start a recursive call to Oracle OLAP because a ROLLBACK past an UPDATE to an attached analytic workspace has been performed.

1 Answers  


ORA-14309: Total count of list values exceeds maximum allowed

1 Answers  


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

1 Answers  


ORA-31010: XML element index string exceeds maximum insertion index string

1 Answers  






Categories