Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

writing file back to OS from BLOB

397179Jan 3 2006 — edited Mar 16 2007
I've written two procedures one to save OS file to BLOB and one to write the file from BLOB back to OS. now when I write the file back to OS the file is getting corrupted. for eg if its a MS word doc file of its a Adobe PDF file, I can't open it after I write it back to OS.

to check what might be the actual problem, I saved a txt file to BLOB and then wore it back to OS. now when i check the txt file, it was showing hex chars.

I've tried using both

utl_file.put_raw(l_output, my_vr );
and
utl_file.put(l_output, UTL_RAW.CAST_TO_VARCHAR2(my_vr))

but the result is same.

can anybody please help?

Thanks a lot

Warm Regards
Vivek Bajaj
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 13 2007
Added on Jan 3 2006
22 comments
3,246 views