Use Dynamic Actions To Update Data
This tutorial will create a dynamic action named 'CALCULATE COMMISSION'. This fires whenever the 'Job' or 'Salary' page items change. Upon change, it does two things. Firstly an AJAX call is fired that retrieves the calculated commission (based on the current values for 'Job' and 'Salary') from calling a PL SQL function. The 'Commission' page item is then set to the calculated commission. It is based on one native action ('Set Value' with a 'Set Type' of 'PL SQL Function Body').
And one dynamic action called 'GET DEPT INFORMATION'. This fires whenever the 'Department' page item changes and invokes an AJAX call that retrieves the 'Location' and 'Number of Employees' information for the selected department from the database. It uses one native action ('Set Value' with a 'Set Type' of 'SQL Statement').
And one dynamic action called 'UPDATE SALARY' is associated with the button on the page. This uses the 'Execute PL SQL Code' event type to update the employee salaries and then uses the 'Refresh' event type to show the updated values in the report.
Source Code Link
===============================================
https://drive.google.com/drive/folder...
00:00 - Introduction
01:30 - Update Salary
04:49 - Get Dept Information
08:00 - List Of Value (LOV) Calc Commission
09:01 - Calculate Commission
