by Dawn Herse » Sun, 31 Dec 1899 09:00:00
by Terry Steyaer » Sun, 31 Dec 1899 09:00:00
static int sqlctx=1 const;
If you bind multiple files together, and have the same sqlctx in each
file, you can receive this error (along with several others.) There is
a patch for this bug, although I haven't seen it released in any full
patches.
If that isn't the problem, I need to know more about your program. Is
this using OCI, embedded SQL, or what? What type of call is giving you
the problem? Does it happen in only one place or in every program that
you write? (If in one place, what's unique about that place.)
Sorry if there are a lot of questions, but something like this isn't
very easy to find. (Being on the end of finding the above bug!)
Terry Steyaert
Sent via Deja.com http://www.deja.com/Quote:> In attempting to call an oracle stored procedure from either C++ or
VB,
> we receive the error "ORA-01008: not all variables bound". The error
> code info gives no detail about this. Can anyone tell me what this
> means? The stored procedure is a simple one that implements a
sequence
> number, returning an integer. It works fine when called from within
> Oracle. Thanks, Dawn
1. ORA-01008: not all variables bound error in WebLOgic connection pooling
I am getting "ORA-01008: not all variables bound" when using the
prepareStatement method when connected via connection pooling with an
OCI driver, but it works when using a direct connection with a thin
ORACLE JDBC driver (classes12.zip). This failure is on both NT and
Solaris 2.6.
Here's the relevant code snippets:
public static Connection conn;
...
Context myCtx = new InitialContext();
javax.sql.DataSource ds = (javax.sql.DataSource)myCtx.lookup("Keown");
conn = ds.getConnection();
...
PreparedStatement myPs = null;
String myAgmntSQL = "select start_dt, end_dt " +
"from sma_agmnts " +
"where agmnt_sys_id = ?";
myPs = myConnect.conn.prepareStatement(myAgmntSQL);
If I hardcode a value like 767 instead of ?, there is no error.
I believe that the error is occurring in the prepareStatement method
as I've inserted system outs before and after it to pin down where it
was failing.
The weblogic.properties file contains this:
weblogic.jdbc.connectionPool.banana=\
url=jdbc:weblogic:oracle,\
driver=weblogic.jdbc.oci.Driver,\
loginDelaySecs=1,\
initialCapacity=1,\
maxCapacity=10,\
capacityIncrement=2,\
allowShrinking=true,\
shrinkPeriodMins=15,\
refreshMinutes=10,\
testTable=dual,\
props=user=pcm8744;password=password;server=dldv
weblogic.allow.reserve.weblogic.jdbc.connectionPool.banana=ba,guest
# Data Source definition for banana
weblogic.jdbc.DataSource.Keown=banana
--
Visit Caribbean Aviation:
http://www.caribbeanaviation.com/
2. Problems with JDBC connections to DB2 6.1 on AIX
3. ORA-01008: not all variables bound .
4. ADO and Recordset level transactions?
5. Urgent !!!! -- ORA-01008: not all variables bound
7. ORA-01008 not all variables bound ?
8. oracle compare rows question
10. OCI: Binding collections (varray), Ora 1008: not all variables bound
11. help!!- jdbc prepared statement=error ora-01008
12. sql loader and ora-01008 (cross posted to tools)