RE: PL/SQL connect
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 4 Mar 2008 13:53:17 -0500
This sounds like a job for a Pro*C program.
If the ID's, passwords, and targets are static you could potentially
define database links for each location and then just use each link in
turn from PL/SQL code, but you cannot issue a connect in PL/SQL code.
-- Mark D Powell --
Phone (313) 592-5148
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Terrian, Thomas J Mr
CTR DLA J6DIB
Sent: Monday, March 03, 2008 3:30 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: PL/SQL connect
Is there anyway to use the SQL Connect command in PL/SQL? I have a
cursor that has all of the necessary components of the Connect command
(id, pw, sid, host, and port) and I want to loop through it and use the
Connect command to sign onto a bunch of databases.
I know I can create data links to handle it but I would prefer to avoid
that if I can.
Any ides?
Thanks,
Tom
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
