-
I have such a problem
TABLE a1 and b1 have the same structure,
ID CHAR(15);
STATUS CHAR(1);
CONTENT CLOB;
a1 in database db_a (in host A),
b1 in database db_b (in host B)
linka_b is Database Link ,which can operate tale b1
in database db_a
CREATE OR REPLACE TRIGGER instob
AFTER UPDATE OF status ON a1
FOR EACH ROW
BEGIN
IF (:NEW.status='3') THEN
INSERT INTO b1@linka_b
VALUES(:NEW.id,:NEW.status,:NEW.content);
END IF;
EN;
when update table a1,the error is follow:
ORA-22990 LOB locators cannot span transactions
What can i do for the error? Help me!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|