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-02778: Name given for the log directory is invalid

1 Answers  


NZE-28754: object storage failure

1 Answers  


ORA-30132: invalid key index supplied

1 Answers  


PCC-02328: undefined struct member

1 Answers  


RMAN-06195: auxiliary database not started

1 Answers  






PLS-00562: a function must return a type.

1 Answers  


RMAN-06136: ORACLE error from auxiliary database: string

1 Answers  


RMAN-06157: validation failed for archived log

1 Answers  


IMG-00899: signature cannot be generated

1 Answers  


QSM-02173: the unique constraints does not exist on the join columns of the inner table

1 Answers  


ORA-01248: file string was created in the future of incomplete recovery

1 Answers  


PLS-00385: type mismatch found at 'string' in SELECT...INTO statement

1 Answers  


Categories