PL/SQL connect

From: Terrian, Thomas J Mr CTR DLA J6DIB <>
Date: Mon, 3 Mar 2008 15:29:59 -0500
Message-ID: <82E215DEED1C8344BF94BBF276A1FB2407798525@COL1SMX11.USE.AD.DLA.MIL>

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 Mon Mar 03 2008 - 14:29:59 CST

Original text of this message