Remote Function Calls.
From: Neil Barton <nbarton_at_dpapplications.com>
Date: Tue, 31 Oct 2000 08:02:00 -0800
Message-ID: <jcCL5.6987$e4.134076_at_e420r-sjo2.usenetserver.com>
Date: Tue, 31 Oct 2000 08:02:00 -0800
Message-ID: <jcCL5.6987$e4.134076_at_e420r-sjo2.usenetserver.com>
Hi,
Within a PL/SQL stored procedure I need to call a remote function, using a database link, with the returned value from the remote function stored in a variable. However, the database link is not known until run time and is passed as a parameter to the stored procedure.. How do you do this ?
e.g v_return_val := remote_package.remote_function_at_DBLINK;
The DBLINK value will not be known until executing the procedure.
Any ideas?
TIA Received on Tue Oct 31 2000 - 17:02:00 CET