Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options

Help on DBI/DBD Oracle needed.

by dba (Monk)
on Apr 23, 2004 at 19:01 UTC ( [id://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?Last hourOther CB clients
Other Users?
Others surveying the Monastery: (5)
As of 2024-05-18 14:18 GMT
Find Nodes?
    Voting Booth?

    No recent polls found