DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Dbms_submit Errors

  1. #1
    Join Date
    Oct 2003
    Posts
    312

    Dbms_submit Errors

    Code:
    var x number
    begin
    dbms_job.submit(:x, 'MY_PROCEDURE;', TRUNC(sysdate)+19/24, 'TRUNC(sysdate)+1+19/24');
    commit;
    end;
    /

    begin
    *
    ERROR at line 1:
    ORA-06550: line 1, column 93:
    PLS-00306: wrong number or types of arguments in call to 'MY_PROCEDURE'
    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 2


    what's wrong with my job scheduling???

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    you rprocedure requires arguemnts

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width