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

RMAN-06131: skip offline/readonly only allowed with current controlfile

1 Answers  


DRG-11841: Bad Gateway

1 Answers  


PLS-00206: %%TYPE must be applied to a variable, column, field or attribute, not to "string"

1 Answers  


DRG-10801: cannot create an SQE for another user

1 Answers  


ORA-03007: obsolete feature

1 Answers  






PCC-02392: You are already in an EXEC SQL DECLARE SECTION

1 Answers  


ORA-02719: osnfop: fork failed

1 Answers  


PCB-00627: Host variable is not of character type

1 Answers  


RMAN-06125: error while looking up archive log key: number

1 Answers  


TNS-00541: underlying transport does not exist.

1 Answers  


NNO-00068: warning: administrative region check failed, next check in number seconds

1 Answers  


ORA-25182: feature not currently available for index-organized tables

1 Answers  


Categories