Home Discussions Questions & Answers PLSQL Function for Importing Report XML Definitions

PLSQL Function for Importing Report XML Definitions

Avatar photoCustomer July 18, 2024 at 6:55 am

We are embedding report import logic within our existing PLSQL stored procedures. What is the specific PLSQL API call to import a report definition supplied as an XML CLOB?

Viewing 2 reply threads
  • Author
    Replies
    • Support July 18, 2024 at 6:19 pm  

      You should use the function `XXEN_API.import_xml(p_xml in clob)`. It takes the XML data as a CLOB input and returns `null` if the import is successful, or an error message if it fails.

    • Avatar photoCustomer July 19, 2024 at 6:42 pm  

      Does this function handle the final database commit, or is that left to the calling procedure?

    • Support July 20, 2024 at 5:33 pm  

      The function does not include a commit. You must explicitly execute a commit from the calling code to finalize the database transaction after a successful import.

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

Login with: