138: argument_name IN VARCHAR2 DEFAULT NULL,
139: argument_type IN VARCHAR2,
140: out_argument IN BOOLEAN DEFAULT FALSE);
141:
142: -- Define an argument with a default value encapsulated in an ANYDATA.
143: -- See other notes for define_program_argument above.
144: PROCEDURE define_anydata_argument(
145: program_name IN VARCHAR2,
146: argument_position IN PLS_INTEGER,
140: out_argument IN BOOLEAN DEFAULT FALSE);
141:
142: -- Define an argument with a default value encapsulated in an ANYDATA.
143: -- See other notes for define_program_argument above.
144: PROCEDURE define_anydata_argument(
145: program_name IN VARCHAR2,
146: argument_position IN PLS_INTEGER,
147: argument_name IN VARCHAR2 DEFAULT NULL,
148: argument_type IN VARCHAR2,
145: program_name IN VARCHAR2,
146: argument_position IN PLS_INTEGER,
147: argument_name IN VARCHAR2 DEFAULT NULL,
148: argument_type IN VARCHAR2,
149: default_value IN SYS.ANYDATA,
150: out_argument IN BOOLEAN DEFAULT FALSE);
151:
152: -- Define a special metadata argument for the program. The program developer
153: -- can retrieve specific scheduler metadata through this argument.
409: -- background by a dedicated job slave.
410: PROCEDURE run_job(
411: job_name IN VARCHAR2,
412: use_current_session IN BOOLEAN DEFAULT TRUE,
413: event_message IN SYS.ANYDATA DEFAULT NULL);
414:
415: PRAGMA SUPPLEMENTAL_LOG_DATA(run_job, NONE);
416: -- Stop a job or several jobs that are currently running. Job name can also be
417: -- the name of a job class or a comma-separated list of jobs.
464: job_name IN VARCHAR2,
465: argument_name IN VARCHAR2,
466: argument_value IN VARCHAR2);
467:
468: -- Same as above but accepts the default value encapsulated in an AnyData
469: PROCEDURE set_job_anydata_value(
470: job_name IN VARCHAR2,
471: argument_position IN PLS_INTEGER,
472: argument_value IN SYS.ANYDATA);
465: argument_name IN VARCHAR2,
466: argument_value IN VARCHAR2);
467:
468: -- Same as above but accepts the default value encapsulated in an AnyData
469: PROCEDURE set_job_anydata_value(
470: job_name IN VARCHAR2,
471: argument_position IN PLS_INTEGER,
472: argument_value IN SYS.ANYDATA);
473:
468: -- Same as above but accepts the default value encapsulated in an AnyData
469: PROCEDURE set_job_anydata_value(
470: job_name IN VARCHAR2,
471: argument_position IN PLS_INTEGER,
472: argument_value IN SYS.ANYDATA);
473:
474: -- This refers to a program argument by its name. It can only be used if the
475: -- job is using a named program (i.e. program_name points to an existing
476: -- program). The argument_name used must be the same name defined by the
474: -- This refers to a program argument by its name. It can only be used if the
475: -- job is using a named program (i.e. program_name points to an existing
476: -- program). The argument_name used must be the same name defined by the
477: -- program.
478: PROCEDURE set_job_anydata_value(
479: job_name IN VARCHAR2,
480: argument_name IN VARCHAR2,
481: argument_value IN SYS.ANYDATA);
482:
477: -- program.
478: PROCEDURE set_job_anydata_value(
479: job_name IN VARCHAR2,
480: argument_name IN VARCHAR2,
481: argument_value IN SYS.ANYDATA);
482:
483: -- Clear a previously set job argument value. All job specific value
484: -- information for this argument is erased. The job will revert back to the
485: -- default value for this argument as defined by the program (if any).
1380:
1381: FUNCTION check_sys_privs RETURN PLS_INTEGER ;
1382: PRAGMA SUPPLEMENTAL_LOG_DATA(check_sys_privs, NONE);
1383:
1384: FUNCTION get_varchar2_value (a SYS.ANYDATA) RETURN VARCHAR2;
1385: PRAGMA SUPPLEMENTAL_LOG_DATA(get_varchar2_value, NONE);
1386:
1387: FUNCTION get_varchar2_value (a BLOB) RETURN VARCHAR2;
1388: PRAGMA SUPPLEMENTAL_LOG_DATA(get_varchar2_value, NONE);