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-09206: sfrfb: error reading from file

1 Answers  


AMD-00155: Object to delete "string" does not exist in Workspace "string"

1 Answers  


EXP-00055: %s.string is marked not exportable

1 Answers  


ORA-06549: PL/SQL: failed to dynamically open shared object (DLL): string

2 Answers  


ORA-19695: fixed table x$krbmsft has not been populated

1 Answers  


CLSS-00002: unable to determine local node number. type string

1 Answers  


PLS-00147: LIBRARY file specification string is empty

1 Answers  


ORA-00399: corrupt change description in redo log

1 Answers  


ORA-13121: layer type type mismatch with topo_geometry layer type

1 Answers  


ORA-01569: data file too small for system dictionary tables

1 Answers  


ORA-01426: numeric overflow

1 Answers  


ORA-27077: too many files open

1 Answers  


Categories