How to convert files stored in LOB data type of Oracle to physical files
-
Dear sir/madam , I had a problem in visual basic 6.0. I would like to crate files at the runtime on VB 6.0 and after that I would like store the same file in the LOB data type provided by the oracle. I am using BLOB for the same and oracle 8i database. After storing the data to the oracle, I would like to open the same file runtime on the application and then after I like to store the same file on the physical disk. Application is about creating any type of file at runtime on the from and adding the same file to the database and on the other node I like to open the same and store file on to the physical disk. Mainly we are going to store image file ,PDF, xls. , and Doc files Kindly provided help on the same. If you can provide me the method and source code then It would be grate help to me Looking forward to your immediate reply. Thanking you in Anticipation with warm regards. Yogesh Dwivedi