Re: How to call stored procedure in remote database via db link??
From: Jurij Modic <jmodic_at_src.si>
Date: Mon, 30 Aug 1999 17:39:42 GMT
Message-ID: <37cbb5e1.10824152_at_news.siol.net>
The above opinions are mine and do not represent any official standpoints of my employer Received on Mon Aug 30 1999 - 19:39:42 CEST
Date: Mon, 30 Aug 1999 17:39:42 GMT
Message-ID: <37cbb5e1.10824152_at_news.siol.net>
On Sat, 28 Aug 1999 21:35:24 +0200, "Willem Kuijk" <willem.kuijk_at_wxs.nl> wrote:
[SNIP]
>create procedure ABC as
>begin
> qrs_at_databaselink_name;
> xyz('Here is the data')_at_databaselink_name;
This one should be:
xyz_at_databaselink_name('Here is the data')
Note that the name of the database link is part of the fully qualified remote procedure name, so the parameter must be specified after it.
>end;
>
>Thats it!
>
>Willem
HTH,
Jurij Modic <jmodic_at_src.si>
Certified Oracle DBA (7.3 & 8.0 OCP)
The above opinions are mine and do not represent any official standpoints of my employer Received on Mon Aug 30 1999 - 19:39:42 CEST