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-06111: NETTCP: disconnect failure

1 Answers  


ORA-12852: PARALLEL_MIN_SERVERS must be less than PROCESSES, string

1 Answers  


NPL-00308: requested ASN.1 class string does not match received class string

1 Answers  


RMAN-06420: some files could not be proxy restored - aborting restore

1 Answers  


ORA-13226: interface not supported without a spatial index

2 Answers  


LPX-00405: unable to allocate memory

1 Answers  


LRM-00123: invalid character number found in the input file

1 Answers   BSNL, IBM,


NNL-00915: Authority required on server queries: string

1 Answers  


NNL-00234: Auto-refresh failure-retry expiration period is currently string

1 Answers  


ORA-09966: scumnt: translation error while expanding ?/dbs/lk

1 Answers  


NZE-28812: record operation failure

1 Answers  


ORA-30014: operation only supported in Automatic Undo Management mode

1 Answers  


Categories