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!

extracting BLOB to file

jdm811Oct 10 2011 — edited Oct 12 2011
i inserted a file to blob using this procedure: http://arjudba.blogspot.com/2008/06/how-to-insert-blob-dataimage-video-into.html

then i want to extract it back to file using this: http://arjudba.blogspot.com/2008/06/how-to-insert-blob-dataimage-video-into.html

i manage to make this work on small files. When i tried inserting 20MB file it was success but when extract it back i'm getting this error:

Error at line 1
ORA-01403: no data found
ORA-06512: at line 37


from what i understand, the script is limited to a certain size... any other solution? thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 9 2011
Added on Oct 10 2011
6 comments
284 views