The whole purpose of using DBD::Oracle is to read BLOB's.I need to set the ora_type to ORA_BLOB when I read it.Also I tried what perrin said, to set ORACLE_HOME before we use any modules. and it does'nt work.Please let me know if you have any other suggestion