ORA22920 from DBMS_LOB.COPY

From: <barryhj_at_my-dejanews.com>
Date: Fri, 16 Apr 1999 17:27:51 GMT
Message-ID: <7f7rub$61o$1@nnrp1.dejanews.com>

SQL> @c:\o8\lobs\lobcopy
DOC>    Version 1.0, last updated 8/8/97
DOC>    This file demonstrates the DBMS_LOB.COPY routine, as described in
DOC>    Chapter 21 of _Oracle8 PL/SQL Programming_ by Scott Urman.  */

DECLARE
*
ERROR at line 1:

ORA-22920: row containing the LOB value is not locked
ORA-06512: at "SYS.DBMS_LOB", line 290
ORA-06512: at line 18

Is this the source of destination LOB that need to be locked? Does the table need a row level locking trigger? Or..... Is this an Oracle8 bug.

I looked through the Oracle Web site and searched the net for insight without success. Where on the web should I look?

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Apr 16 1999 - 12:27:51 CDT