Hi, Shah, you need to put a semicolon after the
procedure name as in 'Purge_log;'.

Regards,

James

--- Shah Rupesh
<oracledba-ezmlmshield-x70259846.[Email address protected]
wrote:
>
> I want to submit a job to run proc 'Purge_log'
> everyday.
>
> Below is the script that is giving error:-
>
> variable a number;
> BEGIN
> DBMS_JOB.SUBMIT(:a,'Purge_log',SYSDATE,'SYSDATE+1');
> commit;
> END;
> /
>
>
> SQL> /
> BEGIN
> *
> ERROR at line 1:
> ORA-06550: line 1, column 103:
> 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 79
> ORA-06512: at "SYS.DBMS_JOB", line 136
> ORA-06512: at line 2
>
>
> Can somebody help whts wrong the script?
>
> Thanks,
> Rupesh
>
>
>
> Our name has changed. Please update your address
> book to the following format: "[Email address
> protected]
>
> This message contains information that may be
> privileged or confidential and is the property of
> the Capgemini Group. It is intended only for the
> person to whom it is addressed. If you are not the
> intended recipient, you are not authorized to read,
> print, retain, copy, disseminate, distribute, or
> use this message or any part thereof. If you receive
> this message in error, please notify the sender
> immediately and delete all copies of this message.
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here:
> http://tahiti.oracle.com
> To unsubscribe: see
> http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>





__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail

Oracle LazyDBA home page