Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

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.


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.

      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?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (8)
As of 2015-07-08 02:59 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (93 votes), past polls