Yes that is it ....

Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 7456019


-----Original Message-----
From: [Email Address Removed] [mailto:[Email Address Removed] Thursday, January 31, 2002 7:56 PM
To: LazyDBA.com Discussion
Subject: Running a package from another instance


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



--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page