On Mon, Dec 12, 2011 at 06:15:40PM +0000, Charles Jardine wrote:
>
> Another way removing the slow-down is to re-authenticate,
> with $dbh->func('uuuu', 'pppp', 'reauthenticate'), after
> each iteration. This causes Oracle to create a new session
> within the existing connection. Re-authentication is much
> faster than creating a new connection. This might provide
> a workaround for you.
Would be good if that could be made available via install_method:
$dbh->ora_reauthenticate('uuuu', 'pppp')
would be both cleaner and, importantly, honour RaiseError etc.
Tim.
