Hello,
Are u performing any exception handeling in Ur
code? Try to capture oracle err mesg using
USER DEFINED EXCEPTIONS. For more detail look
into DBMS_ERROR_CODE and DBMS_ERROR_TEXT
OraCOP
--- Charu Joshi [EMAIL PROTECTED] wrote:
Hi Arup,
Thanks for the reply.
I have
Gurus,
Desperately need some ideas to solve this one.
Following is the sequence of events as it happens:
1. Front-end application (VC++) queries from a view V. V fetches data from a
remote database RD via a database link.
2. Front-end inserts a row in a local table LT.
3. The Insert trigger on
Gurus,
Sorry, forgot to mention one very important fact - this error doesn't occur
always - sometimes (but rarely) it's succeeds as well.
Thanks,
Charu
-Original Message-
Sent: Thursday, November 21, 2002 2:22 PM
To: '[EMAIL PROTECTED]'
(Distributed transaction)
Gurus,
Desperately
Charu,
I guess the error you are getting is Table or Trigger is mutating. and
perhaps you are using an after insert row trigger. This is a common and
expected problem. There are ways to get around it. You have not mentioned
the version of Oracle; I would assume 8.1.7 or later.
Inside an after
Hi Arup,
Thanks for the reply.
I have checked the trigger code thoroughly and surely it's not a mutating
trigger. Nor is there any cascade effect or the trace files would have shown
the statements within that trigger.
There is some other error occurring, but we are not able to trap it because