On Tue, 6 Jul 2004 16:07:28 +0100
Tim Bunce <[EMAIL PROTECTED]> wrote:
> I think in some cases it's better to use
>
> $sth = $dbh->column_info(...)
>
> :)
>
> Tim.
>
hi
I am using
Oracle 8.1.5
DBI 1.42
I tried to use this method like this :
$sth = $dbh->column_info( undef,'OSNP', '%%' , '%%');
but $sth is never defined when I use column_info() -or primary_key_info()- as you
noticed above
when I do something like below, everything is OK.
my $type = "TABLE";
$sth = $dbh->table_info( undef,'OSNP', '%%', $type );
while (my $row = ($sth->fetchrow_arrayref)) {
everything is ok !
}
so everything is ok with $sth = $dbh->table_info(...) but I can't find how to use $sth
= $dbh->column_info(...)
any ideas ?
thanks
Fred
