| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Oracle 8.0.5 LOBS & Trigger
I need to create a trigger to perform application specific auditing on a
table containing a blob (and I do mean BLOB not LONG RAW) column. I
code in the trigger is:
base table
t_item
id number(10) not null PK blobcol blob
I have an insert/update trigger on T_ITEM that tries to do the following
insert into t_item_audit (id, blobcol, mod_dt) values(:new.id, :new.blobcol,sysdate);
When the trigger fires I get the following error:
ORA-22275: invalid LOB locator specified
Any help would be appreciated.
Kirk
Received on Tue Nov 24 1998 - 07:23:47 CST
![]() |
![]() |