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

391531Apr 2 2003 — edited Apr 18 2003

Im launching a Pl/SQL procedure by a DB-Link.
Im using Oracle 8.1.7
i cannot access the procedures code because its wrapped.
i get an error :
ORA-02074: cannot ROLLBACK in a distributed
transaction ORA-06512: at
"DIMENSION.PKGCREATETIMESLOTCALLOUTS", line 204
ORA-02074: cannot SET
SAVEPOINT in a distributed transaction ORA-06512: at
"DIMENSION.PKGTIMESLOT", line 90 ORA-06512: at
"DIMENSION.PKGTIMESLOT", line
617 ORA-06512: at "IMPORT.PK_UID_CLIENT_CONFIG",
line 924 .

Can anyone help me please?
thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 16 2003

Added on Apr 2 2003

2 comments

399 views