Re: How to call stored procedure in remote database via db link??

From: Willem Kuijk <>
Date: Sat, 28 Aug 1999 21:35:24 +0200
Message-ID: <7qas6m$2lla8$>

Albert Chow <> wrote in message news:7q90hp$
> Hello,
> I want to call a procedure which is stored in a remote database. How
> can I use a db link to call it??
> Albert

Just call the procedure as you would normally do, and add at the end of it: _at_databaselink_name;

An example of how you can do it ( is a procedure without parameters, xyz is a remote procedure with an input parameter):

create procedure ABC as

[Quoted]     xyz('Here is the data')_at_databaselink_name; end;

Thats it!

Willem Received on Sat Aug 28 1999 - 21:35:24 CEST

Original text of this message