Rick,
I do this all the time. What I do is to create a local package that simply
calls the remote package. This insulates the local application from any
changes (especially to the db link name). You could also program in a way
to not call the package if db link goes bad for some reason.
below is an example of a remote function call wrapped into a local function.
CREATE OR REPLACE FUNCTION WTWDBA.Iwrt_Wtw_Getmin_Hours_F(
in_cin_id IN VARCHAR2 DEFAULT NULL,
in_case_number_id IN VARCHAR2,
in_district_cd IN VARCHAR2,
in_suffix_id IN VARCHAR2,
in_folder_id IN WTW_FOLDER.FOLDER_ID%TYPE DEFAULT
NULL)
RETURN VARCHAR2 IS
loc_func_result VARCHAR2(10);
BEGIN
loc_func_result := [EMAIL PROTECTED](
in_cin_id,
in_case_number_id,
in_district_cd,
in_suffix_id);
return loc_func_result;
end;
Hope this helps.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Thursday, January 31, 2002 10:56 AM
To: Multiple recipients of list ORACLE-L
Hi DBAs,
I have a package(mail_pkg) in instance SID1. Can I run the package from
instance SID2? If so how do I proceed?
Is it just a matter of creating a db_link. ex. exec mail_pkg.send_mail
(....)@dblink_name.
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mercadante, Thomas F
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
