-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|