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.


Oracle LazyDBA home page