Re: How to call stored procedure in remote database via db link??
From: Willem Kuijk <willem.kuijk_at_wxs.nl>
Date: Sat, 28 Aug 1999 21:35:24 +0200
Message-ID: <7qas6m$2lla8$1_at_reader2.wxs.nl>
Date: Sat, 28 Aug 1999 21:35:24 +0200
Message-ID: <7qas6m$2lla8$1_at_reader2.wxs.nl>
Albert Chow <kwachow_at_netvigator.com> wrote in message
news:7q90hp$9ge2_at_pegasus.hkstar.com...
> 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
begin
qrs_at_databaselink_name;
[Quoted] xyz('Here is the data')_at_databaselink_name;
end;
Thats it!
Willem Received on Sat Aug 28 1999 - 21:35:24 CEST