Hi All.
Please people can you respond to my previous posting? Its a prod problem and
i would really like to get going.
Thanx a lot.
Danny
> -----Original Message-----
> From: Rozengurtel, Daniel
> Sent: Wednesday, January 09, 2002 9:52 AM
> To: '[EMAIL PROTECTED]'
> Cc: Rueth, Loretta F.
> Subject: DBI Problem
>
> 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.
