RE: ORA-02074: cannot Rollback in a distributed transaction

2002-04-24 Thread Boivin, Patrice J 



I 
don't know if this is related to what we are going through here, apparently 
Oracle treats transactions via db link as 2-phase commit transactions unless SET 
TRANSACTION READ ONLY is used.

Check 
dba_2pc_pending to see if you have hung 2-phase commit 
transactions.

If you 
do, do a search in MetaLink to find out how to remove them.

Regards, 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] 
.com

Re: ORA-02074: cannot Rollback in a distributed transaction

2002-04-24 Thread Tim Gorman 



Let the outer-most calling process handle COMMITs 
and ROLLBACKs. Astoredprocedure should concentrate only on 
passing back error conditions appropriately.

  - Original Message - 
  From: 
  [EMAIL PROTECTED] 
  
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Wednesday, April 24, 2002 8:48 
  AM
  Subject: ORA-02074: cannot Rollback in a 
  distributed transaction
  Hello, I have this error 'ORA-02074: cannot Rollback 
  in a distributed transaction' in a stored procedure of PL/SQL. In a 
  FOR LOOP, when I have an error, I make a Rollback in the EXCEPTION and I get 
  this error. I had looed up in the Server Messages but was not helpful. I would 
  like to add that I call this procedure from an another application.(A software 
  tool which we use as a End-User Interface.) Regards M.Emre HANCIOGLUMasterfoods Services GmbHISI Application 
  SupportTel : +49 2162 500-576Fax: +49 2162 41497E-Mail: 
  [EMAIL PROTECTED]