Re: clob problems

A copy of this was sent to carsten <schimpf_at_opus5.de> (if that email address didn't require changing) On Wed, 27 Oct 1999 12:18:27 +0200, you wrote:

> Hi...
>
>I am getting error ORA-22920: "row not locked" and
>ORA-06512: in "SYS.DBMS_LOB", if I try to write my
>clob output stream.
>
>- the clob is initialized with EMPTY_CLOB()
>- i receive clob locator via a stored procedure

is the procedure "selecting the lob FOR UPDATE"? You must use a select for update.

>- i create the outputstream on it

outputstream -- does that mean java? did you disable autocommit?

    connection.setAutoCommit(false);

else, java autocommits -- releasing any and all locks.

>- i do out.write("stuff to write)
>and then it crashes!
>

well, it doesn't crash does it - it successfully returns an error....

>Any ideas??
>
>Thanks,
>
>Carsten (cschimpf_at_gmx.de)

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Oct 27 1999 - 07:53:51 CDT