Re: Pb with CLOB and JDBC

From: Ron Reidy <rereidy_at_indra.com>
Date: Sat, 28 Dec 2002 06:15:39 -0700
Message-ID: <3E0DA3FB.4000604_at_indra.com>

clechenne_at_wanadoo.fr wrote:
> Hi,
> In your app, we try to read a clob using JDBC, but when we've got
> about 32Ko of data in the CLOB, we've got an SQLException (ORA-06512)
> we use clob.substr(clob, clob.lenth,1).
> Help ....

I don't have a lot of experience with clobs, but I think you need to use the DBMS_LOB package to implement this functionality.

--
Ron Reidy
Oracle DBA

Received on Sat Dec 28 2002 - 14:15:39 CET

This message: [ Message body ]
Next message: JL: "ANN: Zip Code/Area Code/Time Zone Data and Program Components"
Previous message: ChgMan: "How to reuse PREPAREd queries in ProC/C++"
In reply to: clechenne_at_wanadoo.fr: "Pb with CLOB and JDBC"
In reply to clechenne_at_wanadoo.fr: "Pb with CLOB and JDBC"
Next in thread: Marian: "Pat, this is my view from NYC"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message