CLOB problem
From: Jul <Julia.Sats_at_sympatico.ca>
Date: Thu, 19 Sep 2002 21:52:56 -0400
Message-ID: <hfvi9.4986$Ox4.1364546_at_news20.bellglobal.com>
Date: Thu, 19 Sep 2002 21:52:56 -0400
Message-ID: <hfvi9.4986$Ox4.1364546_at_news20.bellglobal.com>
I have such code
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
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);