Home Discussions Questions & Answers Programmatic Export of Single Report Definition

Programmatic Export of Single Report Definition

Avatar photoCustomer July 20, 2024 at 12:53 am

Our change management system requires each report definition to reside in its own XML file. If I have a list of reports, how can I programmatically export each one individually?

Viewing 2 reply threads
  • Author
    Replies
    • Support July 21, 2024 at 3:51 am  

      In this scenario, instead of using `export_file_data` for a bundled export, you should use the function `XXEN_API.export_report_` inside a PLSQL loop. This function accepts a single parameter, `p_report_id`, and returns the report XML as a CLOB.

    • Avatar photoCustomer July 22, 2024 at 11:11 am  

      How do I ensure the generated XML file has a clean name based on the report name?

    • Support July 24, 2024 at 1:04 pm  

      When integrating this into a script with `dbms_xslprocessor.clob2file`, you can sanitize the report name using a function like `xxen_report.space_to_underscore(c.report_name)` to create a valid filename.

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

Login with: