check dba_2pc_pending, there may be entries in there. Oracle follows the 2-phase commit method when queries are submitted from stored programming units, it is default behaviour that cannot be changed.
We ran into this with a Web application that was doing remote querying, and Oracle said the only workaround for queries is issue a set transaction read only before the query is submitted. (though maybe this isn't the problem at all for your situation... ) HTH Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des syst�mes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | R�gion des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -----Original Message----- Sent: Friday, February 21, 2003 10:04 AM To: Multiple recipients of list ORACLE-L If on UNIX, running the oerr utility can be helpful to quickly find a bit more information about ORA errors: (I do not know, what's available on Windows). df2hp105 [oracle] => oerr ora 2046 02046, 00000, "distributed transaction already begun" // *Cause: internal error or error in external transaction manager. // A server session received a begin_tran RPC before finishing // with a previous distributed tran. Check if there are any trace files generated to find any clues, else, open an iTAR (??). - Kirti -----Original Message----- Sent: Friday, February 21, 2003 5:19 AM To: Multiple recipients of list ORACLE-L I'm getting the following error while trying to select from table using dblink: ORA-02046 distributed transaction already begun Thanks Manoj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
