Create Job Example

Does anyone have a quick example of how to create a job that calls a procedure and passes 4 parameters to that procedure?

The docs are confusing to me regarding this and haven't found a good example yet. I see the NUMBER_OF_ARGUMENTS parameter, but don't see where values can be passed to the procedure in the job.

This is for Apex 5 on 12.1.0.2. From the Apex page (on button click), we need to call a procedure that maintains users. Someone had said this would best be done via a job. I appears that the procedure can not be called directly from Apex due to needed security privs.

--

Sincerely,

Woody

--

http://www.freelists.org/webpage/oracle-l Received on Wed Nov 11 2015 - 16:53:27 CET