| How to insert a CLOB with Database Link to a remote database in Trigger? [message #370017] |
Wed, 29 November 2000 22:49 |
wjh
Messages: 3
Registered: November 2000
|
Junior Member |
|
|
I have two database(db1,db2) in two host machine(A,B).
Table a1 in database db1,Table b1 in Database B.
The two table have same structure:
ID CHAR(15);
STATUS CHAR(1);
CONTENT CLOB;
dblkb is a databaselink in db1 connecting to db2
My trigger is:
CREATE OR REPLACE TRIGGER INSTOB
AFTER UPDATE OF status ON a1
FOR EACH ROW
BEGIN
IF (:NEW.status = 3 )THEN
INSERT INTO B1@dblkb
VALUES(:NEW.id,:NEW.status,:NEW.content);
END IF;
END;
When updated table a1,error occured ;
ORA-22990: LOB locators cannot span transactions
ORA-02063: preceding line from DBLKB
ORA-06512: at "WJH.INSTOB1", line 6
ORA-04088: error during execution of trigger 'WJH.INSTOB'
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
