in reply to Fetching 2gb Oracle Blobs

That should be no problem. Read the part in the DBD::Oracle docs about LOBs and LONGs. If you still have questions, post 'em.