Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> oracle thin driver + CLOB problem

oracle thin driver + CLOB problem

From: Hoang-Vu PHUNG <hoang-vu_at_freesurf.ch>
Date: 2000/07/05
Message-ID: <8k01jf$6ct$1@news1.sunrise.ch>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US