DBI and column_info() method
From: Sapet Frederic (fsapet_at_infobiogen.fr)
Date: 06/16/04
- Next message: Michael Peppler: "ANN: DBD::Sybase 1.03"
- Previous message: Dennis Breithaupt: "Re: Handling NUMERIC(18) as string? (SOLVED)"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Wed, 16 Jun 2004 15:52:04 +0200 To: dbi-users@perl.org
Hi All,
I am using
Oracle 8.1.5
DBI 1.42
I would like to retrieve some informations from a database using DBI and some of its methods
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 ok !
}
but $sth is never defined when I use column_info() or primary_key_info()
$sth = $dbh->column_info( undef,'OSNP', '%%' , '%%');
I tryed also
$sth = $dbh->column_info( undef,'OSNP', 'PROJECT' , 'PROJECT_ID');#
or
$sth = $dbh->column_info( undef,'OSNP', 'OSNP.PROJECT' , 'PROJECT_ID')
I don't understand why it doesn't work (and I was unable to find an answer using google :o( ).
Anyone have any ideas?
Thanks,
-- Frederic Sapet
- Next message: Michael Peppler: "ANN: DBD::Sybase 1.03"
- Previous message: Dennis Breithaupt: "Re: Handling NUMERIC(18) as string? (SOLVED)"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
|
