10 Replies Latest reply: Mar 27, 2014 2:30 PM by m.moore RSS

    Extract multiple PDF's as .pdf files into a folder

    m.moore

      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