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 )