Create Job Example

  • From: Woody McKay <woody.mckay@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 11 Nov 2015 10:53:27 -0500

Hi,

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

Other related posts: