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-21600: path expression too long

1 Answers  


ORA-08113: composite partition index may not be compressed

1 Answers  


ORA-34344: (MXDSS03) Analytic workspace string is not attached.

1 Answers  


TNS-00221: Pump Connections Total Data Bytes/Second

1 Answers  


ORA-01591: lock held by in-doubt distributed transaction string

1 Answers  


IMP-00400: Warning: Object type "string"."string" already exists with a different typeid

1 Answers  


ORA-15181: Symbol [string] not found in library string, error [string]

1 Answers  


ORA-08178: illegal SERIALIZABLE clause specified for user INTERNAL

1 Answers  


RMAN-06706: could not close file: "string" (reason=string)

1 Answers  


PCC-00013: Unable to open include file "string" at line number in file string

1 Answers  


ORA-22833: Must cast a transient type to a persistent type

1 Answers  


DRG-11005: invalid create index parameter string

1 Answers  


Categories