I've read the docs and tried a few things, but I can't seem
to figure out how to set the FetchHashKeyName => 'NAME_uc'
and have it work for selectall_arrayref. I've tried setting
it *in* the selectall_arrayref call:
my $ary_ref = $dbh->selectall_arrayref($sql, { Columns => {}, FetchHashKeyName =>
'NAME_uc' });
and I've tried setting it as an attribute to the connect:
my $dbh = DBI->connect("DBI:Oracle:host=$host;sid=$sid",
"$user",
"$pass",
{ RaiseError => 1, PrintError => 0, FetchHashKeyName =>
'NAME_uc' }
);
but neither one seems to get me Upper Case(or lower case if I
use Name_lc) keys. How can I get selectall_arrayref, using
Columns = {} to return a reference to an array of hash
references, to return the hash keys in the "case" of my
choosing?
TIA.
--
Hardy Merrill
Mission Critical Linux, Inc.
http://www.missioncriticallinux.com
