Re: How to SPAWN PL/SQL , NEW PROBLEM

At first thank for answers

I was try package dbms_job but error occured:

I was try this example:

 execute
dbms_job.isubmit(122,'shop.se_cart_autoclear',sysdate,'sysdate+1');

 but system answer is:

SQLWKS> execute
dbms_job.isubmit(122,'shop.se_cart_autoclear',sysdate,'sysdate+1');

ORA-06550: line 1, column 116:
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 "SYS.DBMS_JOB", line 104
ORA-06512: at line 2

i recompile package dbms_job without errors procedure se_cart_autoclear working without errors

where is a problem ?

System: Oracle 7.3, NT

-- 
 (-------------------------------------------------------------------)


  ) Name    : Ing. Jakub Dadak (Dadman)                             (

 (  E-mail  : indad_at_fce.vutbr.cz                                     )


  ) Homepage: http://ww2.fce.vutbr.cz/~smdad/                       (

 (  Work    : Programmer, Linux user, WWW surfer                     )


  ) Motto   : Vsechno je jinak !  Things are different !            (

 (-------------------------------------------------------------------)

     !!!!!!!!!!! zmena e-mailu smdad -> indad !!!!!!!!!!