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

PLSQL Function for Importing Report XML Definitions

Avatar photoCustomer Questions & Answers 3 replies

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?

3 replies

  • Support Enginatics

    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

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

  • Support Enginatics

    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.

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