DBMS_LOB.COPY in triggers?
From: Mel Christie <mel_at_sensory.com>
Date: Tue, 27 Apr 1999 16:39:31 -0400
Message-ID: <_xpV2.5875$%L2.256392_at_news6.ispnews.com>
Can you use DBMS_LOB.COPY in triggers?
ORA-04088: error during execution of trigger 'SCIADMIN.ADD_V1_STUDENT_DATA'.
Date: Tue, 27 Apr 1999 16:39:31 -0400
Message-ID: <_xpV2.5875$%L2.256392_at_news6.ispnews.com>
Can you use DBMS_LOB.COPY in triggers?
When copying a blob I get an error:
General SQL error.
ORA-22275: invalid LOB locator specified ORA-06512: at "SYS.DBMS_LOB", line 393 ORA-06512: at "SCIADMIN.ADD_V1_STUDENT_DATA",line 22
ORA-04088: error during execution of trigger 'SCIADMIN.ADD_V1_STUDENT_DATA'.
Any ideas?
- Mel