Search code examples
databaseoracle-databasestored-proceduresdatabase-link

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
Solution

  • The syntax is

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