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-36679: (XSDPART17) workspace object contains a leaf (workspace object) that is not part of the partition dimension workspace object.

1 Answers  


ORA-31402: unrecognized parameter string

1 Answers  


ORA-13135: failed to alter spatial table

1 Answers  


ORA-24960: the attribute string is greater than the maximum allowable length of number

1 Answers  


PCC-00145: This statement can only be used with THREADS=YES

1 Answers  






ORA-38450: error computing a stored attribute for the expression set.

1 Answers  


RMAN-06156: validation succeeded for controlfile copy

1 Answers  


ORA-28137: Invalid FGA audit Handler

1 Answers  


ORA-01174: DB_FILES is string buts needs to be string to be compatible

1 Answers  


ORA-27077: too many files open

1 Answers  


ORA-07597: spguns: $GETJPIW failure

1 Answers  


NNC-00411: invalid default domain name "string"

1 Answers  


Categories