How to execute an Oracle stored procedure via a database link.

Question

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

Answer 1

The syntax is

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