Thanks Doug - my mistake...
> > 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.
Oracle does return uppercase by default, but I was trying to write
a dp independent app, and I couldn't get the 'NAME_lc' to give me
column names in lowercase. But that was because in addition to using
FetchHashKeyName => 'NAME_lc' in the connect, I was also using
my $column_names_arrayref = $sth->{'NAME'};
when I should have been using
my $column_names_arrayref = $sth->{'NAME_lc'};
to get the column names in lower case - I was using the column
names returned from $sth->{'NAME'} to refer to specific columns.
Anyway, thanks for responding - your response made me take a
better look at my script to find out what the real problem was.
Hardy
>
> > 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
