Home › Discussions › Questions & Answers › Physical File Creation from Export API CLOB Output

Physical File Creation from Export API CLOB Output

Avatar photoCustomer Questions & Answers 3 replies

I successfully retrieve the report XML as a CLOB using the export API. Now, what specific Oracle procedure do I need to call to take that CLOB and write it out as a physical XML file on the application server’s filesystem?

3 replies

  • Support Enginatics

    To write the CLOB to the database filesystem, you must use the Oracle procedure `dbms_xslprocessor.clob2file`. This procedure requires three key parameters: the CLOB data, a directory name defined in `dba_directories` (such as ‘OUT_FILE_LOC’), and the desired filename.

  • Avatar photoCustomer

    Is this step mandatory for scripted non-interactive deployments?

  • Support Enginatics

    Yes, this is essential for automating migration tasks using shell scripts, as it allows you to interact with the generated XML files outside of the database.

  • You must be logged in to reply to this post.