ORA-03106 alt. ORA-01008

ORA-03106 alt. ORA-01008

Post by Mattias Wahlber » Fri, 17 Oct 1997 04:00:00

Dear fellow netizens,

Please help me. I get some Oracle errors from my program. The errors are
ORA-03106 and more seldom ORA-01008. The environment where the program
is running is an AIX machine with Oracle ver 7.3.X and SNA server ver
3.1. The AIX version is 4.1.X.

My program is multi-threaded and I have a theory about the SNA
communication disturbing the Oracle handles and structs in memory. How I
don't know. The only thing I know is that if I disable all SNA and run
the program in "simulation"-mode it will run for days and weeks without

Have anybody had similar problems?

If you need more details about setup and program-structure, please


Mattias Wahlberg
Systems Programmer
Noventus Systems AB, Gothenburg, Sweden

Phone: +46-31-7208000
Fax: +46-31-7208010


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:


# Data Source definition for banana
Visit Caribbean Aviation:

2. SQL Windows???

3. ORA-01008: not all variables bound .

4. US-Multiple Cities-Needed: SAP Professionals

5. help!!- jdbc prepared statement=error ora-01008

6. Params limit on xml-sql template?

7. Urgent !!!! -- ORA-01008: not all variables bound

8. Simple SQL problem

9. ORA-01008 not all variables bound ?

10. sql loader and ora-01008 (cross posted to tools)

11. ORA-01008: not all variables bound

12. Ora-01008 from PL/SQL