Hello friends,
I have a problem with DBI.pm module running on Sun5.8. While using
selectall_hashref i get this strange error. I am 100% sure the table to
select from does exist. And that the same statement works on our dev machine
(which is Sun5.6) We also descovered that there is a diference in Versions
of DBI we are using. In production (the one that doesnt work: DBI.pm,v 11.3
2001/08/24 23:33:40 timbo Exp) On the Development (the one that works)
--DBI.pm,v 10.34 2001/03/30 14:35:41 timbo Exp
Can anybody suggest what the problem is?
Thanx a lot people.
sub get_isid_fields{
my $statement="SELECT * from FT_T_ISID WHERE INSTR_ID='0001x660ng'";
my $hash_ref = $dbh->selectall_hashref($statement);
foreach my $rec(@$hash_ref)
{
print "$rec->{'INSTR_ID'} \n";
print "$rec->{'ID_CTXT_TYP'} \n";
}
} #end sub
ERROR:
2002:01:09 06:41:51 | LOG | Log File =>
/box/box408/rundir/logs/dan_test.pl.log.20020109.064151.18829
2002:01:09 06:41:51 | INFO | Starting dan_test.pl
Use of uninitialized value in hash element at
/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/DBI.pm line 1205.
Use of uninitialized value in concatenation (.) or string at
/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/DBI.pm line 1208.
DBD::Oracle::db selectall_hashref failed: Field '' does not exist (not one
of ID_CTXT_TYP END_TMS ISS_ID LAST_CHG_USR_ID INST_MNEM FINSRL_TYP INSTR_ID
START_TMS LAST_CHG_TMS) at dan_test.pl line 44.
DBD::Oracle::db selectall_hashref failed: Field '' does not exist (not one
of ID_CTXT_TYP END_TMS ISS_ID LAST_CHG_USR_ID INST_MNEM FINSRL_TYP INSTR_ID
START_TMS LAST_CHG_TMS) at dan_test.pl line 44.
_____________________________________________________________________
IMPORTANT NOTICES:
This message is intended only for the addressee. Please notify the
sender by e-mail if you are not the intended recipient. If you are not the
intended recipient, you may not copy, disclose, or distribute this message
or its contents to any other person and any such actions may be unlawful.
Banc of America Securities LLC("BAS") does not accept time
sensitive, action-oriented messages or transaction orders, including orders
to purchase or sell securities, via e-mail.
BAS reserves the right to monitor and review the content of all
messages sent to or from this e-mail address. Messages sent to or from this
e-mail address may be stored on the BAS e-mail system.
