Home › Discussions › Questions & Answers › PLSQL API for Immediate (Synchronous) Report Output

PLSQL API for Immediate (Synchronous) Report Output

Avatar photoCustomer Questions & Answers 3 replies

I need to generate a report instantly within a PLSQL routine and capture the file output without submitting a concurrent request. What API handles synchronous execution and returns the file content?

3 replies

  • Support Enginatics

    You use the procedure `xxen_api.run_report`. This executes the report synchronously and returns the output file content (like Excel) in the `x_output_file` parameter, which is of type BLOB.

  • Avatar photoCustomer

    What is the prerequisite initialization sequence before calling `run_report`?

  • Support Enginatics

    You must first call `xxen_report.apps_initialize` to set the session context, and then call `xxen_api.create_run_id_` to get a necessary `l_run_id` before setting parameters and calling `run_report`.

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