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
This question is related to
database
oracle
stored-procedures
database-link
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#
for me, this worked
exec utl_mail.send@myotherdb(
sender => '[email protected]',recipients => '[email protected],
cc => null, subject => 'my subject', message => 'my message'
);
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#
Source: Stackoverflow.com