SQL-02151: Invalid host variable for exact numeric SET
statement item



SQL-02151: Invalid host variable for exact numeric SET statement item..

Answer / guest

Cause: An host variable with an invalid type or length was
used to get or set an exact numeric item in an ANSI dynamic
statement.

Action: Make sure your host variable is and int or short for
C or for COBOL, S9(4) or S9(9) binary/comp/display sign
leading separate.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01637: rollback segment 'string' is being used by another instance (#string)

1 Answers  


DRG-11508: bad or missing string token on line string

1 Answers  


ORA-37006: (AWLISTALL04) number writers

1 Answers  


ORA-38428: too many attributes selected for indexing

1 Answers  


PCC-00020: Unable to obtain define variables at line number in file string

1 Answers  






ORA-01170: file not found 'string'

1 Answers  


RMAN-11005: conflicting media information for piece "string"

1 Answers  


ORA-01529: error closing file 'string'

1 Answers  


ORA-02027: multi-row UPDATE of LONG column is not supported

1 Answers  


ORA-22166: collection is empty

1 Answers  


ORA-06525: Length Mismatch for CHAR or RAW data

1 Answers  


ORA-21612: key is already being used

1 Answers  


Categories