Announcement

Collapse
No announcement yet.

Spooling XML_BLOB columns into separate XML files

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Spooling XML_BLOB columns into separate XML files

    Hi all,

    Has anyone had success writing a SQL script to pull multiple XML files from the XML_BLOB columns?

    I currently have the below script which works well to spool one XML file from one column. But ideally, I want to be able to spool multiple XML files for all the results of a query in one script. Any feedback is appreciated.

    Current script:

    set heading off;
    set pagesize 0 echo off;
    set linesize 32767;
    set long 1000000;
    set trimspool on;
    set LONGCHUNKSIZE 100000;
    spool 'C:\test.xml';
    select xml_blob from i_transmission where i_transmission_no in ('556334214');
    spool off;
Working...
X