Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: connecting to two different instances from a ORA PL/SQL procedure

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

From: Pete Finnigan <plsql_at_petefinnigan.com>
Date: Mon, 1 Dec 2003 11:02:09 +0000
Message-ID: <S$YEH2Ax+xy$QxsH@peterfinnigan.demon.co.uk> 





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:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.


Received on Mon Dec 01 2003 - 05:02:09 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US