|
Subject:
|
ORA-01006
|
|
Posted By:
|
ahrv
|
Post Date:
|
7/2/2003 5:54:25 AM
|
Hello to all.
I am making an application to load the registries of a data base in DB2 to one of Oracle.
I obtain INSERT or UPDATE to execute and use the CallableStatement class to execute it.
It gives the error me in Java; but with SQL EXTRA or Pilot Database no.
ORA-01006 bind variable does not exist
Why it can be?
|
|
Reply By:
|
yasir_lahham
|
Reply Date:
|
9/20/2003 5:45:27 PM
|
Cause of the error: A program issued a BIND call for a variable not listed in the associated SQL statement. Only those variables prefixed by either a colon (:) or ampersand (&) in the SQL statement may be referenced in a BIND call, OBIND or OBINDN.
This error may also be caused by a mismatch between a Precompiler program and the related library, SQLLIB.
Modify the BIND call to reference one of the substitute variables specified in the associated SQL statement.
MHD Yasir Al-lahham
|
