Home » SQL & PL/SQL » SQL & PL/SQL » ORA-02050 error: transaction ID rolled back,some remote dbs may be in-doubt
ORA-02050 error: transaction ID rolled back,some remote dbs may be in-doubt [message #248512] Fri, 29 June 2007 05:00 Go to next message
nagaraju_orafaq
Messages: 2
Registered: September 2006
Location: Hyderabad
Junior Member

Hi,

I've written a package with the below signature when the same is executed from a remote database it is giving ORA-02050 error
but if we check the DBA_2PC_PENDING table after getting the error there is no entry.
Also, sometimes we are not getting this error and sometimes we get this error.
Can any one of you suggest the needful to resolve this?

Thanks in advance.

CREATE OR REPLACE PACKAGE custom.packInterfaces AS
		
    PROCEDURE get_mast(cr_acid IN test1.acid%type,
				cust_name OUT varchar2,
				account_category OUT varchar2,
				account_status OUT varchar2,
				account_dorm_status OUT 
varchar2,
				freeze_type OUT varchar2,
				customer_status OUT varchar2);
				
    PROCEDURE get_inst	(c_acid IN varchar2,
				 Inst_Num In varchar2,
				 Tran_code in varchar2,
				 Inst_Status OUT Varchar2);	

END packInterfaces;
/
Re: ORA-02050 error: transaction ID rolled back,some remote dbs may be in-doubt [message #251632 is a reply to message #248512] Sun, 15 July 2007 15:04 Go to previous message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Do you have an unstable network connection between the database machines?

02050, 00000, "transaction %s rolled back, some remote DBs may be in-doubt"
// *Cause: network or remote failure in 2PC.
// *Action: Notify operations; remote DBs will automatically re-sync when the
//          failure is repaired.

Previous Topic: Build Dynamic Table Name to use in Cursor Definition
Next Topic: Functiond and procedures
Goto Forum:
  


Current Time: Thu Dec 08 08:38:16 CST 2016

Total time taken to generate the page: 0.09897 seconds