in reply to Re: Perl : DBI and Oracle
in thread Perl : DBI and Oracle

I was thinking that too (long columns or LOBs) but when I test that I get an error in addition to not getting any rows back. I don't see anything in the sample code turning off RaiseError or PrintError which, I thought, were on by default. So while a long column would do it, why no error?

At any rate, a description of the table being queried would be useful here, as well as any output.

Replies are listed 'Best First'.
Re: Re: Re: Perl : DBI and Oracle
by aennen (Acolyte) on Jan 09, 2003 at 20:23 UTC
    Figured it out, my env set for ORACLE home was wrong causing this problem. 
    $ENV{"ORACLE_HOME"}="ORACLE_HOME=/oravl01/oracle/8.0.6/";

Should be
$ENV{"ORACLE_HOME"}="/oravl01/oracle/8.0.6/";

    [download]
    Seeing without seeing.... Thanks Alan
[reply]
[d/l]

In Section Seekers of Perl Wisdom