Home › Discussions › Questions & Answers › Programmatic Export of Single Report Definition

Programmatic Export of Single Report Definition

Avatar photoCustomer Questions & Answers 3 replies

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?

3 replies

  • Support Enginatics

    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.

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

  • Support Enginatics

    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.

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