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 when calling proc from VB

mikesiczAug 5 2002

Anyone have any idea why a stored procedure that sets a savepoint will fail with

[Oracle][ODBC][Ora]ORA-02074: cannot ROLLBACK in a distributed transaction
ORA-02074: cannot SET SAVEPOINT in a distributed transaction
ORA-06512: at "PIPS_ADMIN.PKG_ACAS_COMMON", line 1098
ORA-06512: at line 1

when called from Visual Basic via an ADO connection through ODBC BUT

will succeed when called from SQL*Plus or TOAD or other tool.

Any ideas appreciated.

Mike

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 2 2002

Added on Aug 5 2002

0 comments

218 views