Re: 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.

Comment on Re: Perl : DBI and Oracle

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