How to read BLOB data from Oracle and save as a file
Posted on 2004-10-04
I am writing a script using Perl 5.6.1 and the DBI module to read data out of a table created by another program and create an IBM Rational ClearQuest record. I will be using the ClearQuest API to create the record. Some of the rows in the table I am reading contain BLOB data which where attachments added by the user of the other system. In order to get the attachment into the ClearQuest database using its API, I have to reconstruct the BLOB data into a file on the file system. Please send me some code samples that would show me how to read the BLOB data and save it to the file system in its original format (Word, Zip, XML, Text, etc...).