Re: How can I change my script to make multiple connections to do the job

This meets your specifications:

my $conn = 20;

my @dbh = map { DBI->connect ('DBI:Oracle:host=EM12;sid=orcl',"hr","hr
+")
        or die "Failed to connect to database: " . DBI->errstr} 1..$co
+nn;
for my $t (1..$tables){
  my $sql = ....
  $dbh[$t % $conn]->do ($sql) or die DBI->errstr;
}
[download]

What this achieves is less clear.

"By three methods we may learn wisdom: First, by reflection, which is noblest; Second, by imitation, which is easiest; and third by experience, which is the bitterest." -Confucius

Comment on Re: How can I change my script to make multiple connections to do the job Download Code

Replies are listed 'Best First'.
Re^2: How can I change my script to make multiple connections to do the job by terrykhatri531 (Novice) on Jan 10, 2013 at 20:29 UTC
Hi, This is excellent, I love this forum, and thank you very much for your help. Regards Terry	[reply]