Re: connecting to two different instances from a ORA PL/SQL procedure

Hi

use a database link, that you would create first. Then you can select
data form the database you are connected to and also the second database
via the link.

hth

Kind regards

Pete
-- 
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.