Did you read DBD::Oracle's documentation for how to handle this? There are several solutions documented. The most general are Piecewise Fetch With Polling for reading and Binding for Updates and Inserts for CLOBs and BLOBs for writing.

I am not using Oracle so I can't test those solutions. But back when I did I remember using those techniques and finding that they worked exactly as documented.