ORA-02074: cannot ROLLBACK in a distributed transaction
888695Nov 9 2011 — edited Nov 9 2011hello all
I am running a procedure from a 9.2.0.7. The target is a 8.1.6 database. i am running the procedure via dblink.
here is the procedure.
declare
res varchar2(128);
begin
res := siebel.F2S_Listener_syseng@dev.panos.gr ('1-GUV9','2','Δεν υπάρχει Τ.Κ. <440 02> στην πόλη <>');
dbms_output.put_line(res);
end;
the error
ORA-02074: cannot ROLLBACK in a distributed transaction
ORA-06512: at "SIEBEL.F2S_LISTENER_SYSENG", line 269
ORA-02074: cannot ROLLBACK in a distributed transaction
ORA-06512: at line 4
what is the problem?
thanks in advance