PL/SQL connect
From: Terrian, Thomas J Mr CTR DLA J6DIB <Tom.Terrian.ctr_at_dla.mil>
Date: Mon, 3 Mar 2008 15:29:59 -0500
Message-ID: <82E215DEED1C8344BF94BBF276A1FB2407798525@COL1SMX11.USE.AD.DLA.MIL>
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?
Thanks,
Tom
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 03 2008 - 14:29:59 CST