Re: Running procedures remotely

Hi,

The easiest way is to define a synonym (public or private, up to you) for the remote object.
If you have db1 and db2 and a db_link "db2_link" on db1 pointing to db2, and a procedure "proc" owned by "sch" on db2, you can do (logged to db1):

sql> create synonym proc for sch.proc_at_db2_link; sql> execute proc( ... your twenty or so parameters ... )

Hope to be of some help.

Regards,
Maurício.

In article <37CA85A1.D4600922_at_Unforgettable.com>,   BluesSax_at_Unforgettable.com wrote:
> 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
>
>

--
Maurício B. Falleiros <mbf_at_uniconsult.com.br> Uniconsult Sistemas e Serviços

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Aug 30 1999 - 11:28:22 CDT