Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed-east.nntpserver.com!nntpserver.com!news.maxwell.syr.edu!pln-e!spln!dex!extra.newsguy.com!newsp.newsguy.com!news.usenetgateway.com From: mgrogue Newsgroups: comp.databases.oracle.misc Subject: Re: HELP! : ORA-00164: autonomous transaction disallowed within distributed transaction Date: Thu, 10 Oct 2002 20:19:57 +0000 Organization: dBforums Lines: 11 Sender: mgrogue Message-ID: <1914315.1034281197@dbforums.com> References: NNTP-Posting-Host: p-002.newsdawg.com User-Agent: dBforums X-Original-NNTP-Posting-Host: ns.spikeball.com X-Original-Trace: 10 Oct 2002 20:23:49 GMT, ns.spikeball.com Xref: newsfeed1.easynews.com comp.databases.oracle.misc:87688 X-Received-Date: Thu, 10 Oct 2002 13:51:01 MST (news.easynews.com) Do you use PLVISION? If so, the culprit is there. Look for packages/procedures with PRAGMA AUTONOMOUS TRANSACTION (PLV_LOG_IO and PLV_TRACE_IO). Where you find that PRAGMA, comment out those lines. The problem could just as easily be in a different schema, but that is where we found it. -- Posted via http://dbforums.com