in reply to DBD::Oracle::st execute failed

I'm assuming you have a typo in the code you posted as $sth is not mentioned anywhere except in the bind_param call.