Running procedures remotely

From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Mon, 30 Aug 1999 09:22:41 -0400
Message-ID: <37CA85A1.D4600922@Unforgettable.com>

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