Hi All, I have a Stored Package.Procedure which I want to schedule or run adhoc using dbms_scheduler.create_job. For this I have very simple UI from which I can execute this package.procedure but while executing , is there a way I can get a Request Id kind of response, and later using this Request id I can see the status of the from DBA_SCHEDULER_RUNNING_JOBS or DBA_SCHEDULER_JOB_RUN_DETAILS
If multiple users use the UI and Execute the package, how to uniquely identify the execution of the package using dbms_scheduler.
any help is greatly appreciated.
Thanks in advance