How to execute an Oracle stored procedure via a 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

Answers


The syntax is

EXEC mySchema.myPackage.myProcedure@myRemoteDB( 'someParameter' );

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#


Need Your Help

Creating markers on google Map

php javascript google-maps

I am trying to add multiple google markers on a map and I am not sure why this code does not work. I am using php and javascript. I checked to see if $DNB had elements and it did. I am not sure wha...

Skip IDP authentication in SAML

saml saml-2.0 opensaml

I am creating a service provider which talks to third party IDP for authentication. But I have a concern that I have a set of dedicated machines(Desktop,tab) which are highly trusted, so is their a...