Re: clob problems

I'm not clear where your problem lies, but I had a similar problem and the following resolved it:

'Select flda into lob_loc from taba for update no wait;' The 'for update' locks the record.

Regards,
Tim
>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
>- i create the outputstream on it
>- i do out.write("stuff to write)
>and then it crashes!
>
>Any ideas??
>
>Thanks,
>
>Carsten (cschimpf_at_gmx.de)
>
Received on Wed Oct 27 1999 - 07:47:37 CDT