Hi, I have set up two users on a single database instance 'ORACLE'.
These two users are connected via database links. ORACLE_at_PTCSUB for
user1 and ORACLE_at_PTCMAIN for user2.
However when I create triggers to update the two user's tables, I get
this error:
delete towhdavl where towhdid = 'XB1172K'
*
ERROR at line 1:
ORA-02068: following severe error from ORACLE_at_PTCMAIN
ORA-00600: internal error code, arguments: [12700], [3391], [29361035],
[1], [], [], [], []
ORA-06512: at "PTCSUB.TRIG_DELETE_TOWHDAVL", line 7
ORA-04088: error during execution of trigger
'PTCSUB.TRIG_DELETE_TOWHDAVL'
ORA-02063: preceding 4 lines from ORACLE_at_PTCSUB
ORA-06512: at "PTCMAIN.TRIG_DELETE_TOWHDAVL", line 7
ORA-04088: error during execution of trigger
'PTCMAIN.TRIG_DELETE_TOWHDAVL'
This is my trigger:
CREATE OR REPLACE TRIGGER TRIG_DELETE_TOWHDAVL
AFTER DELETE ON TOWHDAVL
FOR EACH ROW
DECLARE
NOREC NUMBER;
BEGIN
SELECT COUNT(*) INTO NOREC FROM TOWHDAVL_at_oracle@ptcmain t WHERE
t.TOWHDID = :OLD.TOWHDID AND t.FRDATE = :OLD.FRDATE;
IF (NOREC = 1) THEN
DELETE FROM TOWHDAVL_at_oracle@ptcmain T
WHERE T.TOWHDID = :OLD.TOWHDID AND T.FRDATE = :OLD.FRDATE;
END IF;
END;
Does anyone have any ideas or suggestions?
Regards
Ian
Software Specialist
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Mar 23 2000 - 02:40:50 CST
