Re: Async triggers ???

A copy of this was sent to narenn_at_my-deja.com (if that email address didn't require changing) On Fri, 10 Sep 1999 19:24:39 GMT, you wrote:

>
>
>Can i confine a transaction which updates a table not to wait for
>till the trigger executes AND not to fail if the trigger fails ? Kind
>of Async trigger or Isolated( from a transaction ) trigger ???
>

there are dbms_jobs -- a trigger can queue a job to happen independently after the parent transaction commits. No waiting, no propagated errors.

In Oracle8i there are autonomous transactions. You can read about them at the link below.

>Appreciate your reply / thoughts
>
>Thanks
>
>-Naren
>Fidelity Investments
>Narendra.Nathmal_at_fmr.com
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Sep 10 1999 - 14:47:04 CDT