I wonder what the difference between "$sid" and "dbi:$db_driver:$db" is. If nothing, it would look like Oracle::DBD might have some kind of weakness regarding multiple active connections, if the fault happens later instead of right at connect time, like on the second time through, with a different value of $dbname.
On Wed, Oct 28, 2020 at 10:06 AM Srikantha <srikanth...@gmail.com> wrote: > > $connection_hash{$dbname} = DBI->connect( $sid, $user, $pass, {AutoCommit > => $autocommit_flag}); -- Not working > my $dbh = DBI->connect("dbi:$db_driver:$db", $user, $pass, { RaiseError => > 1, AutoCommit => 1 }) or die ("failed to login $db_user"); -- Working > -- If you are neutral in situations of injustice, you have chosen the side of the oppressor." -- Bshp. Desmond Tutu