Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-02074: cannot ROLLBACK in a distributed transaction

888695Nov 9 2011 — edited Nov 9 2011
hello 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
This post has been answered by Peter Gjelstrup on Nov 9 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 7 2011
Added on Nov 9 2011
19 comments
732 views