> From: Hardy Merrill [mailto:[EMAIL PROTECTED]]
>
> 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' });
This doesn't work for me either.
> 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 this DOES work for me. I thought Oracle returned uppercase by
default anyway, though. But putting 'NAME_lc' here changes it to
lower case for me.
> but neither one seems to get me Upper Case(or lower case if I
> use Name_lc) keys.
You're sure you're not misspelling it in the connect?
Its 'NAME_lc', not 'Name_lc'...
HTH,
Douglas Wilson
