Re: CLOB problem

Strange. No problem doing this with 9i. Either this is a 8.0.5 bug or you are not seeing what you think you are seeing. It is best to post the full code.

"Jul" <Julia.Sats_at_sympatico.ca> wrote in message news:<hfvi9.4986$Ox4.1364546_at_news20.bellglobal.com>...
> I have such code
> INSERT INTO printjobs (Job#, Buffer) VALUES (printjob, empty_clob());
> select buffer into buf from printjobs where job# = printjob for update;
> DBMS_LOB.WRITE(buf, nChars, nPosition, tmpStr);
>
> at last string I have such error message:
> ORA-22920: row containing the LOB value is not locked
>
> nChars, nPosition and tmpStr - correctly declared and have values
>
> I use Oracle 8.0.5
> Why this problem?
Received on Fri Sep 20 2002 - 19:06:40 CEST