Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!in.100proofnews.com!in.100proofnews.com!cycny01.gnilink.net!cyclone1.gnilink.net!spamkiller.gnilink.net!nwrddc01.gnilink.net.POSTED!53ab2750!not-for-mail From: "Anurag Varma" Newsgroups: comp.databases.oracle.server References: <3F33C5D0.78DDBE14@exxesolutions.com> Subject: Re: Terminating a Job Lines: 24 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Message-ID: Date: Fri, 08 Aug 2003 15:56:17 GMT NNTP-Posting-Host: 138.89.191.222 X-Complaints-To: abuse@verizon.net X-Trace: nwrddc01.gnilink.net 1060358177 138.89.191.222 (Fri, 08 Aug 2003 11:56:17 EDT) NNTP-Posting-Date: Fri, 08 Aug 2003 11:56:17 EDT Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:240111 "Daniel Morgan" wrote in message news:3F33C5D0.78DDBE14@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@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