Re: How to call dynamic remote stored procedure in the dynamic sql
From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: Sat, 23 Aug 2003 20:51:57 -0400
Message-ID: <3278332.1061686317_at_dbforums.com>
Date: Sat, 23 Aug 2003 20:51:57 -0400
Message-ID: <3278332.1061686317_at_dbforums.com>
Originally posted by Charley
> Hi,
>
> My local procedure needs to call a remote stored procedure which
> dblink name is built at the run time depending on the input parameter
> to the local procedure. Therefore depending on the input parameter,
> the remote procedure may reside at different remote databases. Try to
> avoid hardcode value in "if/elsif". Thinking to use dbms_sql and pass
> the dynamically built remote procedure to it but somehow it doesn't
>
>
> thanks,
> Charley
AFAIK... "Somehow it doesn't work" is not an Oracle documented error message :->). Plus no mention of Oracle version and OS.
Regards
/Rauf Sarwar
-- Posted via http://dbforums.comReceived on Sun Aug 24 2003 - 02:51:57 CEST