######################## # Declare Modules ######################## use strict; use warnings; # Other Modules use POSIX qw(strftime); use Time::HiRes qw(time); use Time::Piece; use Time::Seconds; no warnings 'redefine'; use DBI; use DBD::Oracle qw(:ora_types :ora_fetch_orient :ora_exe_modes); . . . . sub connect_to_database($$$) { # Declare the variables my ($db_uid, $db_pwd, $db_sid) = @_; my $dbh; my %attribs = ( PrintError => 0, AutoCommit => 0, RaiseError => 0 ); $dbh = DBI->connect("DBI:Oracle:".$db_sid, $db_uid, $db_pwd , \%attribs ) or die "ERROR: Can't connect to database ($db_uid\@$db_sid): ".$DBI::errstr."\n"; return $dbh; }