Hi,
After the upgrade from 12.1 to 19.12, I got this error when executed this procedure:
USER1:
create database link DBLINK1 connect to R1 using 'GUARD1';
create view USER1.TABLE1 as select * from USER1.TABLE1@DBLINK1;
USER2:
create database link DBLINK1 connect to R1 using 'GUARD1';
create view USER2.TABLE2 as select * from USER2.TABLE2@DBLINK1;
USER3:
create or replace procedure USER3.PRC1(loan in number,
rslt out sys_refcursor) is
begin
open rslt for
select t.LOAN_FILE_NUMBER,
t.SEPAM_UNIQUE_NUMBER,
to_number(t.APPROVAL_AMOUNT) APPROVAL_AMOUNT
from USER1.TABLE1 t,
USER2.TABLE2 p
where t.LOAN_FILE_NUMBER=loan
and t.CONTRACT_TYPE_ID in (35464 ,35468)
and t.CUSTOMER_ID=p.EXTERNAL_REF;
end PRC1;
ERROR AFTER EXECUTE USER3.PRC1:
DISTRIB TRAN P01.261225d5.11.7.1062937
ORA-02050: transaction 11.7.1062937 rolled back, some remote DBs may be in-doubt
is local tran 11.7.1062937 (hex=0b.07.103819)
ORA-02056: 2PC: k2lcom: bad two-phase command number rdonly from coord
insert pending collecting tran, scn=447714966418 (hex=0x000000683de43b92)
ORA-02063: preceding line from DBLINK1