On Wed, Nov 6, 2013 at 4:07 PM, Xinhuan Zheng <xzh...@christianbook.com>wrote:
> I wonder this line of code should be changed to 'DBI->connect(@args) if > ($@)'. If ping failed, that means the connection is already closed, $drh > may be no longer valid, will $drh->connect always return a valid new > connection? What's the difference between DBI->connect vs $drh->connect? The $drh there is a DBI driver, not a database handle. It should return a new connection every time. You can try putting in DBI->connect() there and see if it fixes the problem for you though. If not, I'd suggest reporting the problem as a DBD::Oracle issue. By the way, which Oracle pooling solution are you using and how is it working out for you, aside from this problem? - Perrin