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