{"id":10521,"date":"2020-10-22T13:00:33","date_gmt":"2020-10-22T19:00:33","guid":{"rendered":"https:\/\/traust.com\/?p=10521"},"modified":"2020-10-22T18:19:48","modified_gmt":"2020-10-23T00:19:48","slug":"oracle-apex-js-confirm-and-pl-sql-dynamic-action","status":"publish","type":"post","link":"https:\/\/traust.com\/blog\/oracle-apex-js-confirm-and-pl-sql-dynamic-action\/","title":{"rendered":"Oracle APEX JS Confirm and PL\/SQL Dynamic Action"},"content":{"rendered":"

This blog is about how to use an Oracle APEX<\/a> Dynamic Action to display a JavaScript (JS) confirm message and then run a subsequent PL\/SQL block if confirmed.<\/p>\n[su_spacer size=”30″]\n

Example Scenario<\/h2>\n

Imagine that we have an Interactive Report of Employees.\u00a0 To make the user experience better, we add a trash can icon to each row that will call a delete function (See this blog<\/a>).<\/p>\n

To enhance the UI more, we want to make the confirm box show the name of the employee when the trash can icon is clicked.\u00a0 When the delete action is confirmed, then we want to run the PL\/SQL code to delete the employee selected and refresh the Interactive Report.<\/p>\n[su_spacer size=”30″]\n

Standard Confirm Action Won’t Work<\/h2>\n

We cannot just add a Confirm Action to a Dynamic Action because the name (and id) of our employee will change based on the person selected in the Interactive Report.\u00a0 If we try to use a substitution string in the Confirm Action text for the employee name, it will only be the value of employee name page item on page load.<\/p>\n

\r\nWould you like to delete &P2_EMP_NAME.?\r\n<\/code><\/pre>\n[su_spacer size=”30″]\n
APEX JavaScript Confirm Action Won’t Work<\/h2>\n
If we follow the Oracle APEX JavaScript API<\/a> and use a JavaScript block in a Dynamic Action for the confirm box, it will display the name properly, but it brings up another problem.\u00a0 This is because the PL\/SQL block or any other thing in the Dynamic Action after the JavaScript Confirm box will fire regardless of if the user clicks Ok, Cancel, or closes the popup.<\/p>\n
Implementing the APEX JavaScript confirm message in a different way will give us more flexibility, but it would take many more steps to allow us to execute PL\/SQL from JavaScript.<\/p>\n
\r\napex.message.confirm(\"Do you want to delete \" + $v(\"P2_EMP_NAME\") + \"?\", function( okPressed ){\r\n    if( okPressed ) {\r\n      \r\n    }\r\n});\r\n<\/code><\/pre>\n[su_spacer size=”30″]\n
The Solution<\/h2>\n[su_spacer size=”30″]\n
In order to implement this in the easiest way possible, we need to do the following:<\/p>\n