Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle 8.0.5 LOBS & Trigger

Oracle 8.0.5 LOBS & Trigger

From: Kirk Cameron <cameron_at_bicnet.net>
Date: Tue, 24 Nov 1998 08:23:47 -0500
Message-ID: <365AB362.3851E10D@bicnet.net>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US