We have a created an Oracle 8i database on Suse Linux 7.3
with all the data. I'm currently using Netscape Application Server 4.0 sp5
on NT to connect to the 8i database.
The problem comes up whenever prepared query statements
are used. It does not show any results for prepared query statements
which accepts IN parameter values and has ? in it.
although the most basic query runs fine.

I have registered the datasource to connect to the database and get the
connection fine. Also I'm using the ORACLE_OCI driver in the properties file. The classes111.zip file is present in $ORACLE_HOME/jdbc/lib and the
classpath on the Linux machine is set to this file.

The kjs logs of NAS show the following warnings :

[19/Mar/2002 18:49:24:4] warning: ORCL-042: attempted to add duplicate
column de
scriptor
[19/Mar/2002 18:49:29:1] warning: ORCL-002:
GXORCL2PreparedStatement:AEExecute
(): ORA-22295: cannot bind more than 4000 bytes data to LOB and LONG columns
in
1 statement

Would be really grateful for your help on this.

Amit