I think it's a good idea to recompile the module against the new 9.2.0 database code. Yes, technically the API DBD::Oracle uses might be stable and backward compatible and you might just be able to set $ORACLE_HOME; but, moving from 9.0 to a 9.2 minor version is bound to affect you somewhere down the line. I'd recompile in ALL cases, since it never hurts and can only help if the API has added more features, enhancements or bug fixes.
---
echo S 1 [ Y V U | perl -ane 'print reverse map { $_ = chr(ord($_)-1) } @F;'