I've got an issue with $dbh->column_info for DBD::Oracle.
Basically the function returns undef to me and I've seen the exact same code work under DBD::ODBC.
foreach my $column_nm (@column_nms) {
my $sth = $dbh->column_info(undef, $schema, $table_nm,
$column_nm);
my $hashref = $sth->fetchrow_hashref(); ### line 278
my $type_name = $hashref->{'type_name'};
my $size = $hashref->{'column_size'};}
Basically the fetchrow_hashref fails because: Can't call method "fetchrow_hashref" on an undefined value at /opt/ejpress/ams/cgi-bin/AMSDbMaintenance.pm line 278.
I have 2 setups one of them is a clients (doesn't work) one of them is my local dev (works). Based on http://search.cpan.org/author/TIMB/DBD-Oracle-1.14/Oracle.pm#column_info_ http://search.cpan.org/author/TIMB/DBI-1.37/DBI.pm
Client: I do _not_ have root on this system. uname -a SunOS ejpnode1 5.9 Generic_112233-02 sun4u sparc SUNW,UltraAX-i2 perl -v This is perl, v5.8.0 built for sun4-solaris perl -MDBI -e 'print $DBI::VERSION' => 1.37 perl -MDBD::Oracle -e 'print $DBD::Oracle::VERSION' => 1.14
Local: Win2k SP3 perl -v This is perl, v5.6.1 built for MSWin32-x86-multi-thread perl -MDBD::Oracle -e 'print $DBD::Oracle::VERSION' => 1.14 perl -MDBD::ODBC -e 'print $DBD::ODBC::VERSION' => 1.05
--
END
------------------------------------------------------------------------------
Philip M. Gollucci Consultant E-Mail: [EMAIL PROTECTED] URL : http://p6m7g8.net/Resume/resume.shtml Phone : 301.474.9598
eJournalPress DBA / Software Engineer / System Administrator E-Mail: [EMAIL PROTECTED] URL : http://www.ejournalpress.com Phone : 301.530.6375
$Id: .signature,v 1.4 2003/05/02 23:46:37 philip Exp $
