ORA-01008 : Not all variables bound

I got ” ORA-01008 : Not all variables bound” error in Oracle database.

 

ORA-01008 : Not all variables bound

 

Details of error are as follows.

ORA-01008 not all variables bound

Cause: A SQL statement containing substitution variables was executed without all
 variables bound. All substitution variables must have a substituted value before the 
SQL statement is executed.

Action: In OCI, use an OBIND or OBINDN call to substitute the required values

 

 

Not all variables bound

This ORA-01008 errors are related with the SQL statement containing substitution variables was executed without all
variables bound. All substitution variables must have a substituted value before the SQL statement is executed.

To solve this error, In OCI, use an OBIND or OBINDN call to substitute the required values.

If you used the NULL value, you can get this error, you can use the DBNull.Value instead of NULL.

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )