RE: PL/SQL connect

From: Terrian, Thomas J Mr CTR DLA J6DIB <>
Date: Tue, 4 Mar 2008 13:55:24 -0500
Message-ID: <82E215DEED1C8344BF94BBF276A1FB240779852E@COL1SMX11.USE.AD.DLA.MIL>

Yea, I am going to go ahead and create links.


-----Original Message-----

[] On Behalf Of Powell, Mark D Sent: Tuesday, March 04, 2008 1:53 PM
Subject: RE: PL/SQL connect  

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-----

[] On Behalf Of Terrian, Thomas J Mr CTR DLA J6DIB
Sent: Monday, March 03, 2008 3:30 PM
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?




-- Received on Tue Mar 04 2008 - 12:55:24 CST

Original text of this message