Re: CLOB in JDeveloper

From: aquatone2 <aquatone_at_spamoff.dial.pipex.com>
Date: Thu, 19 Aug 1999 23:08:52 +0100
Message-ID: <7pi1bi$26a$1_at_lure.pipex.net>


bberoukhim_at_my-deja.com wrote in message <7phn56$d4u$1_at_nnrp1.deja.com>...
>Hello,
>
>I have written an app with Jdeveloper connecting to Oraclle 8.1.5.
>The tool is great and I am very satisfied.
>
>There is one problem, I have a table with CLOB type and when try to
>insert with large string. I get the message that the data is larger than
>data type allows. The string is around 3K chracaters.
>
>Why 3K is large for CLOB type?
>
>Is this a Driver problem?
>
>The code is
>
>#sql { UPDATE verityuser.VERITY_LOG
> SET END_TIME = SYSDATE,
> UPDATE_STATUS = :sUpdate_Status,
> UPDATE_NO_OF_IDS = :iUpdateNoOfToc_Frag_ID,
> UPDATE_MKVDK_LOG = :sUpdate_MKVDK_Log, //CLOB Type
> UPDATE_COMMAND = :sUpdateVerityCmd,
> DELETE_STATUS = :sDelete_Status,
> DELETE_NO_OF_IDS = :iDeleteNoOfToc_Frag_ID,
> DELETE_MKVDK_LOG = :sDelete_MKVDK_Log, //CLOB Type
> DELETE_COMMAND = :sDeleteVerityCmd
> WHERE VERITY_LOG_ID = :iMaxVerity_Log_ID

I'm not sure what this code does, but if it generates an SQL UPDATE statement and tries to execute it, then I think I know what the problem is. Oracle can't handle strings longer than a certain length via SQL statements - I seem to recall the limit is around 2000 bytes. I'm not sure whether the limit is in the network layer or the SQL processing.

If this is the case, you need to open a cursor (a.k.a. resultset) on the table and update the row using this.

--

regards,

John

 "Why, sometimes I've fixed as many as six
  impossible bugs before breakfast."
Received on Fri Aug 20 1999 - 00:08:52 CEST

Original text of this message