Skip to Main Content

Oracle Database Discussions

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!

Call a stored procedure over a database link

152933Apr 23 2004 — edited Apr 23 2004
I am familar with database links and synonyms. I have set up a database link
accessing the machine as the correct user (owning the procedure). I can run
"select * from table1@machine1" and that works OK. I try to do a smilar thing
with my procedure "execute proc1@machine1". No luck.

These are the errors that I get:

SQL> execute put_ai@as69('TESTAIC1',33)
begin put_ai@as69('TESTAIC1',33); end;

*
ERROR at line 1:
ORA-02074: cannot ROLLBACK in a distributed transaction
ORA-06512: at "GTADMIN.GT", line 245
ORA-06512: at "GTADMIN.GT", line 1393
ORA-06512: at "GTADMIN.GTAI", line 254
ORA-06512: at "OPS$OCSMGR.PUT_AI", line 7
ORA-02041: client database did not begin a transaction
ORA-02041: client database did not begin a transaction
ORA-06512: at line 1
Regrds
MM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 21 2004
Added on Apr 23 2004
1 comment
329 views