RE: Running a package from another instance

From: Mercadante, Thomas F <Thomas.Mercadante_at_Labor.State.Ny.Us>
Date: Thu, 31 Jan 2002 08:49:01 -0800
Message-ID: <F001.004022D5.20020131084243@fatcity.com>

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 := Wrt_Wtw_GetMin_Hours_F_at_wrtu.nysdss.gov(

                                       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: Rick_Cale_at_teamhealth.com

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: ListGuru_at_fatcity.com (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: Thomas.Mercadante_at_Labor.State.Ny.Us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------