Re: calling stored procedures via dblink
From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 12 Sep 2002 01:50:38 -0700
Message-ID: <a20d28ee.0209120050.17c1749c_at_posting.google.com>
Date: 12 Sep 2002 01:50:38 -0700
Message-ID: <a20d28ee.0209120050.17c1749c_at_posting.google.com>
diegofgb_at_yahoo.com.ar (Diego F Garcia Barquin) wrote in message news:<1121e8b3.0209110819.37879fd6_at_posting.google.com>...
> How do i call a Stored Procedure of another Database via a Dblink?...
> Can i create a synonym of this remote Stored Procedure in my DB?
You don't really need that
The general syntax for remote objects (and a procedure is an object)
is
object_name_at_database_name
in your case just
procedure_name_at_database_name
You can achieve transparency by creating a synonym of course, and I
would do that if you want to avoid hassles.
Hth
Sybrand Bakker
Senior Oracle DBA
Received on Thu Sep 12 2002 - 10:50:38 CEST