Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> oracle thin driver + CLOB problem
Hi,
I'm trying to get this program work. I'm using oracle JDBC thin driver for
java 1.1.x, Oracle 8.1.6
and my java runtime is 1.1.7
My problem is when I execute a call to a stored procedure (named
prototype(in VARCHAR2, out CLOB)),
I get an exception : SQLType is invalid.
Here is a sniff of my code:
OracleCallableStatement ocs =
(OracleCallableStatement )conn.prepareCall("{ call prototype(?, ?) }");
ocs.setString(1, "toto");
// I think this instruction below provokes a SQLException SQLType is
invalid. Why ???
ocs.registerOutParameter(2, OracleTypes.CLOB);
I'm extremely gratefull for any hints,
Regards
Hoang-Vu PHUNG
Received on Wed Jul 05 2000 - 00:00:00 CDT