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

Physical File Creation from Export API CLOB Output

Avatar photoCustomer October 14, 2023 at 5:22 pm

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?

Viewing 2 reply threads
  • Author
    Replies
    • Support October 16, 2023 at 2:36 am  

      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 October 16, 2023 at 7:00 am  

      Is this step mandatory for scripted non-interactive deployments?

    • Support October 18, 2023 at 6:42 am  

      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.

Viewing 2 reply threads
  • You must be logged in to reply to this post.

Login with: