Re: Perl : DBI and Oracle

[rbc]

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.

[steves]

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.

[aennen]

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/";

Seeing without seeing.... Thanks Alan