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-19812: cannot use string without DB_RECOVERY_FILE_DEST

1 Answers  


ORA-12201: TNS:encountered too small a connection buffer

1 Answers  


PCC-00032: Invalid option "string"

1 Answers  


ORA-19567: cannot shrink file string because it is being backed up or copied

1 Answers  


SQL*Loader-00471: OID or SID clause has an argument that is CONSTANT

1 Answers  






ORA-14075: partition maintenance operations may only be performed on partitioned indices

1 Answers  


ORA-01583: unable to get block size of controlfile to be backed up

1 Answers  


LPX-00661: Failed to load: '~s'.

1 Answers  


ORA-10632: Invalid rowid

1 Answers  


ORA-27121: unable to determine size of shared memory segment

1 Answers  


ORA-25277: cannot grant or revoke object privilege on release 8.0 compatible queues

1 Answers  


DRG-10015: id exceeds limit(2147483642) of a number

1 Answers  


Categories