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

Thread: dbms_job not runing

  1. #1
    Join Date
    Mar 2002
    Posts
    303

    dbms_job not runing

    I run this portion of code and i become a error:

    declare
    v_jobnum number;
    v_what varchar2(2000) :='dbms_utility.analyze_schema(''USER'',''compute'')';
    v_next_date date :=sysdate;
    v_interval varchar2(200) :='sysdate+1/3';
    begin
    dbms_job.submit
    (job => v_jobnum,
    what => v_what,
    next_date => v_next_date,
    interval => v_interval);
    commit;
    end;
    /

    Error:
    declare
    *
    ERREUR Ó la ligne 1 :
    ORA-06550: Ligne 1, colonne 141 :
    PLS-00103: Symbole "END" rencontrÚ Ó la place d'un des symboles suivants :
    := . ( % ;
    Symbole ";" a ÚtÚ substituÚ Ó "END" pour continuer.
    ORA-06512: a "SYS.DBMS_JOB", ligne 79
    ORA-06512: a "SYS.DBMS_JOB", ligne 131
    ORA-06512: a ligne 7

    in init.ora i already set:
    job_queue_processes=36
    job_queue_interval=60

    What should i do?

  2. #2
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    Add a semicolon:
    v_what varchar2(2000) :='dbms_utility.analyze_schema(''USER'',''compute'');';
    Ales
    The whole difference between a little boy and an adult man is the price of toys

  3. #3
    Join Date
    Jan 2002
    Posts
    113
    You have a syntax error. Change:

    v_what varchar2(2000) :='dbms_utility.analyze_schema(''USER'',''compute'')';

    to

    v_what varchar2(2000) :='dbms_utility.analyze_schema(''USER'',''compute'');';


    You seem to be missing a semi-colon ( near the end of the line. I ran it and it works.

    Dean
    Arm yourself with knowledge

  4. #4
    Join Date
    Mar 2002
    Posts
    303
    Thank's all it's work

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