lhoward has asked for the wisdom of the Perl Monks concerning the following question:

I have a large base of code working off of an oracle database that is using perpare_cached for performance reasons. I'm having problems where the statement handle is going bad because of a change in the underlying database. Is there any way to force DBI to verify in perpare_cached that the statment handle is still valid and if not re-prepare it? Would doing so void the performance gains I get from using prepare_cached?