Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Running procedures remotely
Here is the general idea for something I need to do but am not quite
sure how I would do it.
I have two servers and both are running Oracle databases. The first server has some real-world connectivity for telephony functions which use Oracle and the second machine has a database which is used as a repository for a variety of other data items.
When certain events occur on the first server I want to be able to run a pl/sql stored procedure on the remote machine and pass it about 20 parameters and then get a result set back which would then be used by the telephony functions.
I know how to define a database link, so that isn't my problem, but what I don't know is how I would call a procedure that doesn't reside in the local database.
Can anyone help?
Ken Received on Mon Aug 30 1999 - 08:22:41 CDT