create table employees_log(
who varchar2(30),
when date); CREATE PROCEDURE order_toa
AS
Insert into employees_log(Who,when)
Values( user, sysdate);
GOvariable jobno number;
execute dbms_job.submit(:jobno,'order_toa;',trunc(sysdate,'hh')+1/48,'trunc(sysdate,''hh'')+1/48')
这里讲无效的SQL语句...
variable jobno number;
execute dbms_job.submit(:jobno,'order_toa;',trunc(sysdate,'hh')+1/48,'trunc(sysdate,''hh'')+1/48')那个大哥能帮我看看,在线等 谢谢了
who varchar2(30),
when date); CREATE PROCEDURE order_toa
AS
Insert into employees_log(Who,when)
Values( user, sysdate);
GOvariable jobno number;
execute dbms_job.submit(:jobno,'order_toa;',trunc(sysdate,'hh')+1/48,'trunc(sysdate,''hh'')+1/48')
这里讲无效的SQL语句...
variable jobno number;
execute dbms_job.submit(:jobno,'order_toa;',trunc(sysdate,'hh')+1/48,'trunc(sysdate,''hh'')+1/48')那个大哥能帮我看看,在线等 谢谢了
execute dbms_job.submit(:jobno,'order_toa;',trunc(sysdate,'hh')+1/48,'trunc(sysdate,''hh'')+1/48')
这里讲无效的SQL语句...
variable jobno number;
execute dbms_job.submit(:jobno,'order_toa;',trunc(sysdate,'hh')+1/48,'trunc(sysdate,''hh'')+1/48')
end;
execute dbms_job.submit(:jobno,'order_toa;',trunc(sysdate,'hh')+1/48,'trunc(sysdate,''hh'')+1/48')
end这样还是不行啊 大哥
declare
jobno number;
begin
execute dbms_job.submit(jobno,'order_toa;',trunc(sysdate,'hh')+1/48,'trunc(sysdate,''hh'')+1/48');end;
jobno number;
begin
execute dbms_job.submit(jobno,'order_toa;',trunc(sysdate,'hh')+1/48,'trunc(sysdate,''hh'')+1/48');
end;大哥这样写是可以定义了 ,可是下面这句话有问题 了
execute dbms_job.submit(jobno,'order_toa;',trunc(sysdate,'hh')+1/48,'trunc(sysdate,''hh'')+1/48');
出现符号DBMS_JOB在需要下列只一时::=.(@%;immediate符号":="被 替换为DBMS_JOB后续.
错误信息是这样的.
drop table EMPLOYEES_LOG;
CREATE TABLE EMPLOYEES_LOG(
WHO VARCHAR2(30),
WHEN DATE);--不要写成sqlserver语法
CREATE OR REPLACE PROCEDURE order_toa AS
BEGIN
INSERT
INTO employees_log(Who, WHEN) VALUES(USER, SYSDATE);
COMMIT;
END;
/
variable jobno number;
--从现在开始,每半小时,如果要整点执行可稍加修改
exec dbms_job.submit(:jobno,'order_toa;',sysdate,'sysdate+1/48');
--打印JOBid
print jobno;
--注意提交
commit;
老兵把你的全部复制过去执行
variable jobno number;
--从现在开始,每半小时,如果要整点执行可稍加修改
exec dbms_job.submit(:jobno,'order_toa;',sysdate,'sysdate+1/48');
--打印JOBid
print jobno;
--注意提交
commit;这还是不行 无效的SQL语句.[
[/code]