reauthenticate - was: Problem with Oracle collections/objects

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.