Re: Critical! Trigger errors for Oracle 8.0.5

You have one instance and you are using database links? Why on earth are you doing that?????
If I look at your code you have a sort of gordian knot which should be entangled asap.
PCTMAIN calls PCTSUB calls PCTMAIN? Yuck Your database links must use a local loopback connector. Shouldn't they be completely redundant?
You should be able to arrange this by grants and synonyms. Verify with Support and they'll probably advise you to get rid of this mechanism too.
Sorry to be so outspoken.

Regards,

Sybrand Bakker, Oracle DBA

<ianlo_at_clarity.com.sg> wrote in message news:8bclah$5gh$1_at_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 - 03:37:33 CST