How to get image out from LONG RAW from the database

10-11  Source: Network gathering  Views:0 

Advertisement
Dear fellow Oracle users
I have a table about 50,000 rows one of the the column is LONG RAW.. and we store image files within this column ... almost 99% is gif format.
Does anyone able to recommand a way to get ALL these images out of the database and save it into a directory. May be a batch process or may be some kind of tools?
Not all the rows consists of images (i.e some of the the long raw can be null for some row) .
Any sample codes are very much appreciated...(I am okay with PL/SQL , a little rusty with Java coding but okay to pick it up again...)
regards
Ivan
Hi,
if u are using oracle forms than u can integrate Webutil with it, there are many function available within webutil to do this.
Thanks
Related articles