Home › Discussions › Questions & Answers › PLSQL API for Importing Report XML Definitions

PLSQL API for Importing Report XML Definitions

Avatar photoCustomer Questions & Answers 5 replies

We need to import XML files containing report metadata automatically into our production system via PLSQL. What function in `XXEN_API` handles the XML upload?

5 replies

  • Support Enginatics

    You can use the function **`XXEN_API.import_xml(p_xml in clob)`**. This function takes the report XML data as a CLOB input.

  • Avatar photoCustomer

    What does the function return upon success?

  • Support Enginatics

    The function returns `null` if the import is successful, or an error message if it fails.

  • Avatar photoCustomer

    Since this is PLSQL, is an explicit commit required after calling the function?

  • Support Enginatics

    Yes, the `import_xml` function does not include a commit, so you must explicitly execute a commit from the calling code to finalize the database transaction.

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