You might try adding use DBD::Qracle qw(:ora_types);. I have found in some curcumstances that has increased my efficency. You may also want to try using named place holders. I do not know what effect that will have on speed, but it may increase maintainability. also with named palce holders you can pass in a hash ref with TYPE => ORA_INTEGER or similar.