Re: Terminating a Job

From: Anurag Varma <avarmadba.skipthis_at_yahoo.com>
Date: Fri, 08 Aug 2003 15:56:17 GMT
Message-ID: <BKPYa.261$aE1.219@nwrddc01.gnilink.net>

"Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message news:3F33C5D0.78DDBE14_at_exxesolutions.com... --snip--
> Set up your UTL_SMTP procedure as an autonomous transaction with PRAGMA
> AUTONOMOUS_TRANSACTION. That may keep it from hanging the job. I'd be
> interested in knowing whether it works.
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
>

Daniel,

Setting it as an autonomous_transaction won't really make it asynchronous. The calling
procedure will still wait for it to finish. I do not see why it would work?

Anurag Received on Fri Aug 08 2003 - 10:56:17 CDT