Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: HELP! : ORA-00164: autonomous transaction disallowed within distributed transaction

Re: HELP! : ORA-00164: autonomous transaction disallowed within distributed transaction

From: mgrogue <member_at_dbforums.com>
Date: Thu, 10 Oct 2002 20:19:57 +0000
Message-ID: <1914315.1034281197@dbforums.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


Received on Thu Oct 10 2002 - 15:19:57 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US