语句如下,报错如下
报调用存储过程时参数个数或类型错误
-- 创建定时任务,判断如果已有这个定时任务,则删除重建
DECLARE JobNum NUMBER(5) := 0;
JobID NUMBER(5) := 0;
BEGIN
SELECT COUNT(*) INTO JobNum FROM DBA_JOBS WHERE UPPER(SUBSTRB(WHAT,1,30)) = UPPER('P_SCE_LOG_PayVerifyNochange');
IF JobNum > 0 THEN
SELECT NVL(JOB,0) INTO JobID FROM DBA_JOBS WHERE UPPER(SUBSTRB(WHAT,1,30)) = UPPER('P_SCE_LOG_PayVerifyNochange');
IF JobID > 0 THEN
DBMS_JOB.REMOVE(JobID);
COMMIT;
END IF;
END IF;
END;
/
DECLARE
v_Job NUMBER;
BEGIN
DBMS_JOB.SUBMIT(v_Job, 'P_SCE_LOG_PayVerifyNochange;', TRUNC(SYSDATE, 'HH24'), 'SYSDATE + 1/96');
COMMIT;
END;
/
报调用存储过程时参数个数或类型错误
-- 创建定时任务,判断如果已有这个定时任务,则删除重建
DECLARE JobNum NUMBER(5) := 0;
JobID NUMBER(5) := 0;
BEGIN
SELECT COUNT(*) INTO JobNum FROM DBA_JOBS WHERE UPPER(SUBSTRB(WHAT,1,30)) = UPPER('P_SCE_LOG_PayVerifyNochange');
IF JobNum > 0 THEN
SELECT NVL(JOB,0) INTO JobID FROM DBA_JOBS WHERE UPPER(SUBSTRB(WHAT,1,30)) = UPPER('P_SCE_LOG_PayVerifyNochange');
IF JobID > 0 THEN
DBMS_JOB.REMOVE(JobID);
COMMIT;
END IF;
END IF;
END;
/
DECLARE
v_Job NUMBER;
BEGIN
DBMS_JOB.SUBMIT(v_Job, 'P_SCE_LOG_PayVerifyNochange;', TRUNC(SYSDATE, 'HH24'), 'SYSDATE + 1/96');
COMMIT;
END;
/
解决方案 »
- wrap 加密好是出错
- 请高手老鸟们帮帮忙把我的查询语句优化一下,谢谢了~
- 关于PL/sql的问题
- 在线求助一源代码:在Oracle Database环境下,用P/LSQL写数据查询中的交叉表SQL语句.
- 请问哪里可以下载oracle816nt.zip?
- 一个数据库多表查询的问题,各位老大们帮帮忙吧,都要急死了!
- 大家能讨论一下ORACLE比之SQLSERVER的优点在哪里吗?
- 帮帮我
- oracle驱动问题求教
- 求助!我安装完oracle应用程序开发工具后进入Oracle9i Designer或Repository Object Navigator等工具时,需要输入登陆:username,passwo
- oracle 数据检索后修改部分字段再插入---在线等
- command window,SQL window,Test window,Report window这些窗口的区别?
DECLARE
v_Job NUMBER;
BEGIN
DBMS_JOB.SUBMIT(v_Job, 'declare
varlist;
begin
procedurename(varlist);
end;', TRUNC(SYSDATE, 'HH24'), 'SYSDATE + 1/96');
COMMIT;
END;
/