存储过程:
CREATE OR REPLACE PROCEDURE spSynchronization
(
r_number OUT NUMBER
)
---------------这样是不行的----------------------
Declare
jobno number;
outrs number;
begin
sys.dbms_job.submit(jobno,
'pSynchronization(outrs);',
to_date('24-11-2005 10:56:50', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'sysdate+1/24');
commit;
end;
CREATE OR REPLACE PROCEDURE spSynchronization
(
r_number OUT NUMBER
)
---------------这样是不行的----------------------
Declare
jobno number;
outrs number;
begin
sys.dbms_job.submit(jobno,
'pSynchronization(outrs);',
to_date('24-11-2005 10:56:50', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'sysdate+1/24');
commit;
end;
请指导!
写一个没有参数的过程调用,然后放到JOB里调用
方案二:
写一个语句块
declare
a number;
begin
spSynchronization(a);
end;Declare
jobno number;
outrs number;
begin
sys.dbms_job.submit(jobno,
'declare
a number;
begin
spSynchronization(a);
end;',
to_date('24-11-2005 10:56:50', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'sysdate+1/24');
commit;
end;
as
a number;
begin
spSynchronization(a);
end;
/然后在job 的what 中调用 aa 即可