• 请不要在回答技术问题时复制粘贴 AI 生成的内容
brucewuio
V2EX  ›  程序员

关于数据库定时器调用有参存储过程

  •  
  •   brucewuio · Dec 3, 2018 · 1958 views
    This topic created in 2727 days ago, the information mentioned may be changed or developed.
    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
    No Comments Yet
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Solana   ·   1438 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 108ms · UTC 17:03 · PVG 01:03 · LAX 10:03 · JFK 13:03
    ♥ Do have faith in what you're doing.