Maintaining Transaction logs on tables in Oracle 8.0.4....
From: Ian Sparks <isparks_at_spam-me-not-wmute.u-net.com>
Date: Fri, 12 Feb 1999 16:02:43 -0000
Message-ID: <XfYw2.1571$V3.2564_at_newsr2.u-net.net>
Hi,
Date: Fri, 12 Feb 1999 16:02:43 -0000
Message-ID: <XfYw2.1571$V3.2564_at_newsr2.u-net.net>
Hi,
CREATE TABLE mydata
(
cID NUMBER(10,0),
.....
cChanges BLOB
)
CREATE TABLE mydata_Trans
(
cID NUMBER(10,0),
.....
cChanges BLOB,
cRevisionID NUMBER(10,0)
)
My problem is that I get ORA-22275 Invalid Blob Locator errors in my myData table triggers when trying to copy data via INSERT statements into the Transaction table :
INSERT INTO myData_Trans (cID,..,cChanges) VALUES
(:new.cID,...,:new.cChanges);