in reply to DBD::ORACLE - empty strings in result while there supposed to be values
Hmmm ... well I would think you're either not connecting to the same server (probably not) or you're not in the database you think your in. At a minimum, your sql could be failing but you're not checking the status of your execute. I would put some error checking in place or at least set RaiseError.
my $dbh = DBI->connect( "dbi:Oracle:host=$host;port=$port;sid=$sid", $user, $passwd, {RaiseError => 1} );
|
|---|