I understand, that for security reasons it is not possible to call a OS Program from Browser.
To do that with a schedule job is one way.
But it would be nice if Oracle would develop anything, that you could call an OS Program directly from the Browser in an easy way.
My scenario is
1. Apex page 1: Store List Report, click the store you want to process, the selected store id and store name will be passed to apex page 2 automatically.
2. Apex page 2: Show the store ID and Store Name, once confirm click a button on the screen. I already created dynamic action of the button to run a bash script in OS via dbms_scheduler.
My issue is i don't know how to get the store id and pass it to the bash script through dbms_scheduler.
You'd want to run a procedure on a schedule that does a query to get your information, THEN execute the bash script which can then be passed the parameters.. I've done similar in the past with java packages in the database (EE)
from that point of view, you'd have to insert those values into a table, then set up the procedure (invoked by an application process from apex) such that it queries for those values (based on some criteria.. flag those that are processed?) then submit the job with those parameters all within the procedure (the table would basically be a queue of parameters to be used for each job)
That will only work if the needed value is stored (submitted) in the session state -- the plsql process wont "See" the [end user] selected value on the webpage link that was clicked -- the only way to achieve this would be to use the AJAX/ondemand methods to "send the value" along with the on-demand execution of the process.
Got error "•ORA-06550: line 17, column 7: PLS-00103: Encountered the symbol "ARGUMENT_VALUE" when expecting one of the following: ) , * & = - + < / > at in is mod remainder not rem <an exponent (**)> <> or != or ~= >= <= <> and or like like2 like4 likec between || multiset member submultiset The symbol "," was substituted for "ARGUMENT_VALUE" to continue"