喷血！！！schedule.job的job action 怎么传递Procedure的参数？

TOADLover

schedule.job的job action 怎么传递Procedure的参数？

[ 本帖最后由 TOADLover 于 2009-10-12 10:27 编辑 ]

wq_1228

参照下面代码，应该可以实现，也是从其他地方找的，不是原创啊，呵呵

-- create a stored procedure with two arguments
create or replace procedure myproc (arg1 in varchar2, arg2 in varchar2)
is BEGIN null; END;
/

-- create a program with two arguments and define both
begin
dbms_scheduler.create_program
(
program_name=>'myprog',
program_action=>'myproc',
program_type=>'STORED_PROCEDURE',
number_of_arguments=>2, enabled=>FALSE
) ;

dbms_scheduler.DEFINE_PROGRAM_ARGUMENT(
program_name=>'myprog',
argument_position=>1,
argument_type=>'VARCHAR2',
DEFAULT_VALUE=>'13');

dbms_scheduler.DEFINE_PROGRAM_ARGUMENT(
program_name=>'myprog',
argument_position=>2,
argument_type=>'VARCHAR2');

dbms_scheduler.enable('myprog');
end;
/

-- create a job pointing to a program and set both argument values
begin
dbms_scheduler.create_job('myjob',program_name=>'myprog');
dbms_scheduler.set_job_argument_value('myjob',1,'first arg');
dbms_scheduler.set_job_argument_value('myjob',2,'second arg');
dbms_scheduler.enable('myjob');
end;
/

TOADLover

大家都不会？还是。。。。什么？

TOADLover

接分？？？？

ziggler

BEGIN
DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE (
   job_name                => 'ops_reports',
   argument_position       => 2,
   argument_value          => '12-DEC-03');
END;
schedule.job的job action 怎么传递Procedure的参数？(页 1) - Oracle - ChinaUnix.net - powered by Discuz! Archiver (21 October 2009)
http://bbs3.chinaunix.net/archiver/tid-1592414.html