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,
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);