Re: DBMS_JOB.SUBMIT error

You are missing a boolean flag indicating whether the procedure that you are scheduling should be parsed when it is submitted. Default is FALSE, so:

  job_num INTEGER;

  dbms_job.submit(job_num,

                            'refresh_snap_f',
                           sysdate,
                           'trunc(sysdate) + 31/24',
                           FALSE);

cheers,
cindy

NetComrade wrote:

> I tried submitting a job and got an error. I've been using an example
> from PL/SQL book
>
> SQLWKS> variable v_job_num number
> SQLWKS> execute dbms_job.submit(:v_job_num, 'refresh_snap_f', sysdate,
> 'trunc(sysdate) + 31/24')
> ORA-06550: line 1, column 108:
> PLS-00103: Encountered the symbol "END" when expecting one of the
> following:
>
> := . ( @ % ;
> The symbol ";" was substituted for "END" to continue.
> ORA-06512: at "SYS.DBMS_JOB", line 71
> ORA-06512: at "SYS.DBMS_JOB", line 121
> ORA-06512: at line 2
>
> so I tried this
> begin
> dbms_job.submit(:v_job_num, 'refresh_snap_f', sysdate, 'trunc(sysdate)
> + 31/24');
> end;
> /
>
> I also trying re-running dbmsjob.sql from $ORACLE_HOME/rdbms/admin,
> but it didn't help.
> ---------------
> Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 373-5417
> AOL: NetComrade ICQ: 11340726 remove NSPAM to email
Received on Wed Dec 01 1999 - 17:22:42 CST