Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

Re: Perl : DBI and Oracle

by rbc (Curate)
on Jan 09, 2003 at 19:38 UTC ( [id://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.

[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

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://225623]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? • Last hour • Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (3)
As of 2024-04-19 20:23 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found