Re: Describe table
From: Sapet Frederic (fsapet_at_infobiogen.fr)
Date: 07/06/04
- Next message: Ron Reidy: "RE: Best Way to Auto Increment with Oracle"
- Previous message: Jeff Zucker: "Re: Possible DBI logos"
- In reply to: Tim Bunce: "Re: Describe table"
- Next in thread: Tim Bunce: "Re: Describe table"
- Reply: Tim Bunce: "Re: Describe table"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 6 Jul 2004 18:11:18 +0200
On Tue, 6 Jul 2004 16:07:28 +0100
Tim Bunce <Tim.Bunce@pobox.com> 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
- Next message: Ron Reidy: "RE: Best Way to Auto Increment with Oracle"
- Previous message: Jeff Zucker: "Re: Possible DBI logos"
- In reply to: Tim Bunce: "Re: Describe table"
- Next in thread: Tim Bunce: "Re: Describe table"
- Reply: Tim Bunce: "Re: Describe table"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
