SQL-02152: Invalid numeric variable for use in an array
GET/SET statement
- 1 Answers
- 2210 Views
- I also Faced
- E-Mail Answers
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 |
TNS-00001: INTCTL: error while getting command line from the terminal
ORA-32823: subscriber exists for queue string and destination string
ORA-35280: (SNSYN165) The format of the AGGREGATE command is: AGGREGATE varname1 [varname2 varname3 ...] USING aggmap-name [COUNTVAR intvar-name1 [intvar-name2 intvar-name3 ...]] [FUNCDATA] [THREADS #]
TNS-01409: Instance "string"
ORA-04052: error occurred when looking up remote object stringstringstringstringstring
ORA-32821: subscriber queue and exception queue must have same payload type
RMAN-06702: could not initialize for input file: "string"
NNL-00248: General request processing is now disabled
PLS-00606: cursor subquery is not supported on client side in this release
ORA-31078: error in SQL mapping information
ORA-07249: slsget: open error, unable to open /proc/pid.
NNC-00430: Database not accessible
Oracle Errors 
