Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

PCB-00201: Indicator variable string not a group item

1 Answers  


ORA-36666: (XSDPART04) workspace object is not a concat dimension.

1 Answers  


ORA-36770: (XSPGERRPERMDETACH) Parallel updating analytic workspace string failed

1 Answers  


PCC-02206: Host variables are not permitted within a DDL statement

1 Answers  


NNL-00916: Modification requests enabled: string

1 Answers  






PROC-00006: User does not have permission to perform a cluster registry operation on this key.

1 Answers  


ORA-14094: invalid ALTER TABLE EXCHANGE PARTITION option

1 Answers  


ORA-12562: TNS:bad global handle

1 Answers  


ORA-14616: table is not subpartitioned by List method

1 Answers  


PLS-00666: Only index by binary_integer/pls_integer associative arrays allowed here

1 Answers  


IMP-00076: Missing NLS_NCHAR_CHARACTERSET in props$

1 Answers  


QSM-01042: anchor and matching join arc check failed for string

1 Answers  






Categories