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 CEST