use DbConn; use Data::Dumper; eval{ local $SIG{ALRM} = sub { print "Alarm Captured\n" ; exit ; } ; my $Sleep_Obj= DbConn->New(); alarm 10 ; $Sleep_Obj->connection('db_name','hostip','username','password'); alarm 0; }; if ($@) { print "Timed out.\n"; } else { print "Connected Successfully\n"; } #### package DbConn; use DBI; use Data::Dumper; sub New { my ($Class)=shift; my $Self = {}; bless($Self, $Class); return $Self; } sub connection { shift @_; my ($DBname, $Host, $User_Name, $Password)=@_; my $dbh = DBI->connect("dbi:Pg:dbname=$DBname;host=$Host","$User_Name","$Password",\%attr ) || die $DBI::errstr; return $dbh; #return the database handle } 1;