On Tue, Jul 06, 2004 at 06:11:18PM +0200, Sapet Frederic wrote:
> 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(...)
> >
> > :)
> I am using
> Oracle 8.1.5
> DBI 1.42
DBD::Oracle ?
> 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 ?
(Why '%%' and not '%'?)
Enabling trace will show you what's happening.
Tim.
