Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?

Help on DBI/DBD Oracle needed.

by dba (Monk)
on Apr 23, 2004 at 19:01 UTC ( #347712=perlquestion: print w/replies, xml ) Need Help??

dba has asked for the wisdom of the Perl Monks concerning the following question:

I loop through a list of databases to query. When I mix   $dbh = DBI->connect($tns,$uid,$pswd,{ ora_session_mode =>2}) with  DBI->connect($tns,$uid,$pswd), (based on the database) perl crashes at the end of the program. However, if I use only one way to connect, it exits normally. Any one used this, or have any suggestions to fix this error ?

Replies are listed 'Best First'.
Re: Help on DBI/DBD Oracle needed.
by Anneq (Vicar) on Apr 23, 2004 at 20:46 UTC

    Do you get any errors? Perhaps if you add:

    or die $DBI::errstr;

    to the end or your connect statements, that might give you some idea what is going on.

    Good luck,


      Thanks for the reply. I do it in every connect. However, connect /query runs fine. I have also a print statement as the last line of the code, which executes just fine. But when perl exits, it crashes.

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://347712]
Approved by Paladin
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (4)
As of 2022-07-02 15:03 GMT
Find Nodes?
    Voting Booth?
    My most frequent journeys are powered by:

    Results (103 votes). Check out past polls.