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

NID-00506: SETNAME Set a new database name only NO

1 Answers  


ORA-07607: szaud: $SNDOPR failure

1 Answers  


PLS-01412: Use of 'EXP' token

1 Answers  


ORA-33429: (EIFMAKEF17) CAUTION: NTEXT expression will be exported with type TEXT.

1 Answers  


ORA-13458: GeoRaster metadata SRS error

1 Answers  






ORA-08178: illegal SERIALIZABLE clause specified for user INTERNAL

1 Answers  


ORA-12432: LBAC error: string

1 Answers  


ORA-32740: The requested operation cannot be proceeded

1 Answers  


ORA-16081: insufficient number of processes for APPLY

1 Answers  


ORA-19598: can not backup SPFILE because the instance was not started with SPFILE

1 Answers  


LSX-00172: "~S" is not a valid restriction of "~S"

1 Answers  


ORA-12592: TNS:bad packet

1 Answers   BoCom,


Categories