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