I am currently using a small script to test out part of a larger script I will use llater on. I am querying Oracle 10.1 to return a column which holds a blob value. This value needs unzipped, sent to a file or piped and then amended and re-inserted to another table with the news values. When I run the small test script below I get this error:
Obviously it dosent dump a BLOB to stdout but thats my question I guess, how do I get the data from within the BLOB and unzip it to a file or pipe in SOLARIS?
I believe you will have to write something in a language that supports binary objects -
probably C or java, or Oracle Forms. Oracle stores these objects in binary format, so sqlplus doesn't know how to "display" them because the format could be anything - a zip file, jpeg, etc.