Call a stored procedure over a database link
152933Apr 23 2004 — edited Apr 23 2004I 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