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
