Paul,
It might help if you gave us the error message(s).
Mark
----- Original Message -----
From: "Paul Tjapkes" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 19, 2001 11:59 AM
Subject: DBD::Oracle persistent connection
> I have a script that needs to be connected to Oracle
> all the time. Everything works fine until Oracle goes
> down for a cold backup.
>
> My code looks something like this:
>
> # Start of script
> $dbh = DBI->Connect("dbi:Oracle:$db",$un,$pw);
>
> # Within a large loop
> unless ($dbh->ping) {
> $dbh->disconnect;
> undef $dbh;
> sleep(1800);
> $dbh = DBI->Connect("dbi:Oracle:$db",$un,$pw);
> }
>
> The problem is that the connect will continue to fail,
> even when Oracle is back up. The only way to
> reconnect is to restart the script. And ideas?
>
> TIA
>
> __________________________________________________
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail - only $35
> a year! http://personal.mail.yahoo.com/
>
