Upgrade your DBI. Looks like you are using an older version. This bug was
fixed I believe. You should be able to run fine without the -w switch if
you can't upgrade.
Ilya
-----Original Message-----
From: Rozengurtel, Daniel
To: '[EMAIL PROTECTED]'
Sent: 1/9/02 10:12 AM
Subject: FW: DBI Problem
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.
