running procedure on remote db???
326015Aug 14 2003 — edited Aug 19 2003I have 2 database machine, let's say dbA and dbB.
I have procedures/functions on dbB that I want to execute from dbA.
I've already make a synonim on dbA for the procedure/function that I would like to call on dbB.
I'm developing web application VB .net via ODP .net wants to access this procedure/function, but it doesn't work, the error message:
ORA-04052: error occurred when looking up remote object pc1.PK_OP_DOCFORMULA@dblink1 ORA-00604: error occurred at recursive SQL level 1 ORA-02041: client database did not begin a transaction
Trying to wrap the procedure call into a local procedure/function doesn't work either. My Proc doesn't contain ANY transaction at all, I don't use any transaction from .NET either, the contents of the procedure is just very simple -test- variable assignment operation.
running the remote procedure via the synonim, using SQL Plus working OK, no problem at all.
Does ODP .net supports calling procedure or any other database objects that reside on separate database machine via DBLink??
if not, is there a way to do this? I'm building application using .NET and oracle?