in reply to Perl : DBI and Oracle

Are any of the columns you are selecting of type long?
Or contain large amount of text?
If so you check this node out.

Replies are listed 'Best First'.
Re: Re: Perl : DBI and Oracle
by steves (Curate) on Jan 09, 2003 at 19:47 UTC

    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.

[reply]
      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