On Mon, Nov 01, 2004 at 04:13:42PM -0500, Jason White wrote:
>
> Here's the client environment I'm working with ...
> perl 5.6.1
> DBI 1.42
> DBD 1.06
FYI DBD::Oracle 1.06 is over 4 years old.
> my $sql=q{select * from myDataView where fld1='value' and fld2 LIKE
> 'VALUE2%'};
> my $seats;
> my $sth = $dbh->prepare($sql);
>
> while ($row_ref = $sth->fetchrow_hashref()) {
> ....
> my $STS_ISS = $row_ref->{STS_ISS};
> ...
> }
> All the other values come out OK .. and they are all VARCHAR2, but the
> STS_ISS field is a NUMBER(3)
>
> I get (what seems like) the raw binary back from the oracle sever ...
> something like:
> STS_ISS - ^V
Please generate a trace file (level 4 should be detailed enough).
Then post an *extract* that covers the prepare() call, the execute()
[that you've not shown], and a fetchrow_hashref call returning the
bad data.
Tim.
