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-32311: materialized view definition query selects an unsupported user-defined type

1 Answers  


TNS-12571: TNS:packet writer failure

1 Answers  


DRG-12803: invalid text datatype

1 Answers  


ORA-28595: Extproc agent : Invalid DLL Path

1 Answers  


LRM-00118: syntax error at 'string' at the end of input

1 Answers  


RMAN-06483: changed datafile copy expired

1 Answers  


RMAN-06453: RECOVERABLE may only be used with datafile objects

1 Answers  


ORA-02208: duplicate MAXTRANS option specification

1 Answers  


ORA-31434: purge is currently running

1 Answers  


ORA-01507: database not mounted

1 Answers  


NNO-00807: End of Fetch: OCI_NO_DATA

1 Answers  


ORA-14062: one or more of table's partitions reside in a read-only tablespace

1 Answers  


Categories