PL/SQL connect

  • From: "Terrian, Thomas J Mr CTR DLA J6DIB" <Tom.Terrian.ctr@xxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 3 Mar 2008 15:29:59 -0500

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?



Other related posts: