Organizational Research By

Surprising Reserch Topic

how to execute an oracle stored procedure via a database link


how to execute an oracle stored procedure via a database link  using -'database,oracle,stored-procedures,database-link'

Can I call a stored procedure in Oracle via a database link?

The database link is functional so that syntax such as...

SELECT * FROM myTable@myRemoteDB


is functioning.  But is there a syntax for...

EXECUTE mySchema.myPackage.myProcedure('someParameter')@myRemoteDB

    

asked Oct 7, 2015 by amit_cmps
0 votes
8 views



Related Hot Questions

1 Answer

0 votes

check http://www.tech-archive.net/Archive/VB/microsoft.public.vb.database.ado/2005-08/msg00056.html

one needs to use something like

cmd.CommandText = "BEGIN foo@v; END;" 

worked for me in vb.net, c#

answered Oct 7, 2015 by ankitarajoria4

...