How to execute an Oracle stored procedure via a database link
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#
The syntax is
EXEC mySchema.myPackage.myProcedure@myRemoteDB( 'someParameter' );