How do you call a procedure through a database link?
Printable View
How do you call a procedure through a database link?
procedure@linkname(arg1, arg2)
Say you have a simple addition procedure that returns the sum, and it's on another database with a link name db1.domain
in pl/sql you could have
result := additon@db1.domain(2, 2);
you might need the schema too name depending on how the link is set up.