APEX integration

Oracle Application Express

APEX & SQLWord integration explained

The SQLWord Apex demo application is based on Oracle HR-tables and demonstrates how to integrate SQLWord with Apex. In this post the implemention of a Job offer letter in an Apex page is explained. The MSWord template HR_Employee_Job_Offer.docx is the source document for this letter. We assume that you have compiled this template to stored procedure HR_EMPLOYEE_JOB_OFFER.

Start the SQLWord HR Demo application and choose Employees from the menu


Select employee David Austin to go to the Detail page 3:




Click on button Job Offer to generate the Microsoft Word document


How does it work?

Open page 3


Examine the source code from the On Demand process CREATE_JOB_OFFER_DOCX




  • Stored procedure HR_EMPLOYEE_JOB_OFFER is called with parameter value :P3_EMPLOYEE_ID.
  • The output document is stored in a local variable L_BLOB by calling function SQLWORD.GET_OUPUT_DOCX.
  • An Apex collection is used to store the data.
  • After processing a branch to page 500 is done


Open page 500

This is a generic empty page for downloading prepared documents.


Examine the source code from (On Load – Before Header) process DOWNLOAD_DOCX



  • The output document and filename is retrieved from the Apex collection.
  • The HTML header is prepared.
  • By calling Apex procedure WPG_DOCLOAD.DOWNLOAD_FILE the download will start.
  • Page 500 is closed an the browser returns back to page 3.