Re: execute a stored procedure remotely

From: Marc Billiet <Marc.Billiet_at_village.uunet.be>
Date: Thu, 18 Jun 1998 22:53:39 +0200
Message-ID: <6mc0o1$ojh$1@xenon.inbe.net>

The syntax is normally:
stored_procedurename_at_databaselink

but you can also create a synonym:

create synonym remote_proc for stored_procedurename_at_databaselink;

Now you can just call remote_proc(parameters);

Lisa Lewis wrote in message <6m6nsi$6og$1_at_usenet01.srv.cis.pitt.edu>...
>Can I execute a stored procedure in database A from a stored procedure in
>database B via a database link? If so, what is the syntax of the call to
>the stored procedure. (I know how to create the db link).
>
>Thanks
>Lisa
>
>
Received on Thu Jun 18 1998 - 15:53:39 CDT