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

Home -> Community -> Usenet -> c.d.o.misc -> Critical! Trigger errors for Oracle 8.0.5

Critical! Trigger errors for Oracle 8.0.5

From: <ianlo_at_clarity.com.sg>
Date: Thu, 23 Mar 2000 08:40:50 GMT
Message-ID: <8bclah$5gh$1@nnrp1.deja.com>


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

Original text of this message

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