Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer

Re: Perl : DBI and Oracle

by rbc (Curate)
on Jan 09, 2003 at 19:38 UTC ( #225623=note: print w/replies, xml ) Need Help??

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.

      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

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://225623]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (5)
As of 2016-10-23 13:30 GMT
Find Nodes?
    Voting Booth?
    How many different varieties (color, size, etc) of socks do you have in your sock drawer?

    Results (301 votes). Check out past polls.