On Fri, Jan 16, 2004 at 12:35:18PM +0100, H.Merijn Brand wrote:
> I don't know if this is DBI or DBD::Oracle's fault, but it is _very_ annoying!
>
> Given that I have to write perl scripts that work on different type of
> databases, and that we chose to only use lowercase table and field names, and
> given the fact the Oracle is so stupid to return uppercase everywhere, I
> thankfully use the FetchHashKeyName => "NAME_lc" attribute
FetchHashKeyName
^^^^^^^^^ - it only affects fetching hashes (e.g. fetchrow_hashref).
> my @name = @{$sth->{NAME}};
> lep a5:/tmp 119 > perl dbi.pl
> NAME: PARM C_USR WAARDE OMSCHR
>
> D'uh!!!!!
>
> Do you understand why I *hate* Oracle?
You asked for $sth->{NAME} so you got what Oracle returned.
If you wanted lowercase names you'd use $sth->{NAME_lc}.
(And if you wanted FetchHashKeyName to influence that
you'd use $sth->{ $sth->{FetchHashKeyName} })
Tim.
