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

TNS-02510: Invalid numeric data type

1 Answers  


KUP-11001: files not from the same unload operation

1 Answers  


ORA-18000: invalid outline name

1 Answers  


QSM-01006: query rewrite disabled for this query block

1 Answers  


ORA-08316: sllfsk: Error seeking in file.

1 Answers  






ORA-14400: inserted partition key does not map to any partition

1 Answers  


RMAN-06735: Do you really want to drop the database (enter YES or NO)?

1 Answers  


ORA-16809: multiple warnings detected for the database

1 Answers  


ORA-25966: join index cannot be based on an index organized table

1 Answers  


ORA-25457: evaluation function string returns failure

1 Answers  


NZE-28824: invalid encryption/decryption/signature state passed

1 Answers  


RMAN-08538: channel string: no autobackup in string days found

1 Answers  


Categories