fionbarr has asked for the wisdom of the Perl Monks concerning the following question:
the data is contained in db_data.pm...there are two distinct filesuse strict; use warnings; use DBI; require db_data; print "length = " . $#LoH . "\n"; foreach (0..$#LoH) { &connect($_, $LoH[$_]{database}, $LoH[$_]{hostname}, $LoH[$_]{servicename}, $LoH[$_]{port}, $LoH[$_]{username}, $LoH[$_]{password}, ); } sub connect { my ($count, $database, $hostname, $servicename, $port, $username, +$password) = @_; print "\n\n$count -> $database\n"; print "\t$hostname\n"; print "\t$servicename\n"; print "\t$port\n"; print "\t$username\n"; print "\t$password\n"; my $dbh = DBI->connect( "dbi:Oracle:host=$hostname; service_name=$servicename; port=$port", "$username", "$password" ) || die "Database connection not made"; print "connected to $database\n"; $dbh->disconnect(); } ########################################################### # db_data.pm use strict; use warnings; package db_data; my @LoH = ( { database => 'Pxxxxx', hostname => 'wpprd0.com', servicename => 'pqxxxx', port => '9010', username => 'mmmmmm'', password => 'pl', }, ) ; 1;
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re: require a module and import array data
by Corion (Patriarch) on Apr 09, 2015 at 14:09 UTC | |
by fionbarr (Friar) on Apr 09, 2015 at 14:40 UTC | |
by Corion (Patriarch) on Apr 09, 2015 at 14:49 UTC | |
by fionbarr (Friar) on Apr 09, 2015 at 14:52 UTC | |
by Anonymous Monk on Apr 09, 2015 at 14:56 UTC | |
by fionbarr (Friar) on Apr 09, 2015 at 14:51 UTC | |
by Corion (Patriarch) on Apr 10, 2015 at 06:18 UTC | |
by Anonymous Monk on Apr 09, 2015 at 14:47 UTC | |
by fionbarr (Friar) on Apr 09, 2015 at 15:04 UTC |