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

score 58 · Accepted Answer · answered Oct 27 '08 at 17:45

58

The syntax is

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

answered Oct 27 '08 at 17:45

Justin Cave

227,342
24
367
384

1

@xtsoler - That would work for a stored function, not a stored procedure. – Justin Cave Sep 20 '16 at 19:04
Do you know how can i invoke a stored procedure with parameters? – Afaria Jul 05 '17 at 20:10
@Afaria - The example I posted is passing a parameter (the string 'someParameter'). – Justin Cave Jul 05 '17 at 21:13

score 1 · Answer 2 · edited Oct 26 '12 at 09:44

1

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#

edited Oct 26 '12 at 09:44

kleopatra

51,061
28
99
211

answered Feb 16 '12 at 15:27

tptp

21
1

score 0 · Answer 3 · edited Feb 26 '21 at 16:05

0

for me, this worked

exec utl_mail.send@myotherdb(
  sender => 'myfromemail@giggle.com',recipients => 'mytoemail@giggle.com, 
  cc => null, subject => 'my subject', message => 'my message'
);

edited Feb 26 '21 at 16:05

mustaccio

18,234
16
48
57

answered Feb 25 '21 at 17:47

george fortech

3
4

How to execute an Oracle stored procedure via a database link

3 Answers3

Linked