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-08278: Cannot get CPU statistics

1 Answers  


TNS-01300: ERROR at string

1 Answers  


NNL-00218: Ignoring spurious trailing text "string"

1 Answers  


ORA-12434: invalid audit type: string

1 Answers  


LFI-00102: Unable to seek in sequentially accessed file.

1 Answers  






ORA-06413: Connection not open.

1 Answers  


TNS-12593: TNS:no registered connection

1 Answers  


ORA-13241: specified dimensionality does not match that of the data

1 Answers  


NNL-01052: Server has been running for: string

1 Answers  


QSM-01025: materialized view, string, not found

1 Answers  


ORA-15002: parameter LOCK_NAME_SPACE exceeds limit of string characters

1 Answers  


ORA-23309: object string.string of type string exists

1 Answers  


Categories