WHAT v15
The WHAT
procedure changes the stored procedure that the job executes.
WHAT(<job> BINARY_INTEGER, <what> VARCHAR2)
Parameters
job
Identifier of the job whose stored procedure you want to change.
what
Name of the stored procedure to execute.
Examples
Change the job to run the list_emp
procedure:
BEGIN DBMS_JOB.WHAT(104,'list_emp;'); END;
- On this page
- Parameters
- Examples