这是一个创建于 2217 天前的主题，其中的信息可能已经有所发展或是发生改变。
DECLARE
x NUMBER;
B VARCHAR2(1) := 'a';
A VARCHAR2(1) := 'b';
BEGIN
dbms_job.submit(
JOB => x,
WHAT => 'P_DEAL_GIFT_SELLPACKAGE50_ST(A,B);',
NEXT_DATE => SYSDATE,
INTERVAL => 'TRUNC(sysdate,''mi'')+1/24/60*15'
);
END;
但是出现了如下错误:
ORA-06550: line 1, column 122:
PLS-00201: identifier 'A' must be declared
ORA-06550: line 1, column 93:
PL/SQL: Statement ignored
ORA-06512: at "SYS.DBMS_JOB", line 79
ORA-06512: at "SYS.DBMS_JOB", line 136
ORA-06512: at line 6
, Time: 0.029000s
我的天啊 我不是刚刚在上面声明了吗 怎么-_- ||
DB 试过 oracle
x NUMBER;
B VARCHAR2(1) := 'a';
A VARCHAR2(1) := 'b';
BEGIN
dbms_job.submit(
JOB => x,
WHAT => 'P_DEAL_GIFT_SELLPACKAGE50_ST(A,B);',
NEXT_DATE => SYSDATE,
INTERVAL => 'TRUNC(sysdate,''mi'')+1/24/60*15'
);
END;
但是出现了如下错误:
ORA-06550: line 1, column 122:
PLS-00201: identifier 'A' must be declared
ORA-06550: line 1, column 93:
PL/SQL: Statement ignored
ORA-06512: at "SYS.DBMS_JOB", line 79
ORA-06512: at "SYS.DBMS_JOB", line 136
ORA-06512: at line 6
, Time: 0.029000s
我的天啊 我不是刚刚在上面声明了吗 怎么-_- ||
DB 试过 oracle
目前尚无回复
Select Language