User creates an Actionable Query in AppDesigner. He has the basic code below. How to use the returned value of AppDesigner Actionable Query to run other scripts or perform other actions?
begin
delete from <table_name> where timestamp < trunc(sysdate,'MONTH');
commit;
:RESULT := 1;
exception
WHEN OTHERS
THEN
:RESULT := 0;
end;
The Actionable Query is used to pass back a True or False value of the result of the SQL Query or PLSQL block. In the example code above, if for any reason, the Delete statement cannot be executed, for example, due to existing table constraints, then RESULT will return False.
User can then create a Conditional Control Action that will run other actions depending on the outcome of your Actionable query. An example would be the usage of "If..Then..Else" action as such:
1. Create two new actions for True and False returns of the Actionable Query.
2. Select Control tab in AppDesigner and create an "If..Then..Else" action
3. Using the mouse, drag and drop the saved Actionable query to "IF add action" line of the IF block.
4. Drag one of actions created in step 1, and drop it to the "Then add action" line of the IF block.
5. Drag another action created in step 1, and drop it to the "Else add action" line of my IF block.
6. Right-click on the "IF" line to run the "If..Then..Else" action
