I've looked, but have not found a way to do this. I have a table (call it TSTATEMENTS) in which one column is a blob containing a pdf. In another column is a name for that PDF. I want to run a query on tstatements filtering on other columns of tstatements. For example:
SELECT FILENAME, PDF_BLOB,
FROM TSTATEMENTS
WHERE rep_name = 'Joe Smith';
----------------------------------
FILENAME | PDF_BLOB |
---------------------------------
g23.pdf | (HUGEBLOB) |
g77.pdf | (HUGEBLOB) |
L4G.pdf | (HUGEBLOB) |
----------------------------------
Then I want to tell SQL DEVELOPER to write out these HUGEBLOBs to 3 files in a windows folder so that I end up with
3 PDF files named g23.pdf, g77.pdf, L4G.pdf. I can do this in TOAD, but we can not afford to buy another copy of TOAD just for this one feature.
Thanks!
Mike