And a trace() shows... ?
Tim.
On Wed, Aug 20, 2003 at 12:24:50PM -0400, Philip M. Gollucci wrote:
> Hi,
>
> 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 $
>
>
>
