Re: How to SPAWN PL/SQL , NEW PROBLEM

Jakub Dadak wrote:
> Official exapmle from DBMS_JOB.SQL by Oracle:
>
> execute dbms_job.submit(:x,'pack.proc(''arg1'')',sysdate,'sysdate+1');
>
> Bye

True, they made a mistake on that example (and me too was misled by that same mistake as you were). But to be honest, it is obvious that it is a typo, because a few lines back in the same script it is explicitly noted that trailing semicolon is mandatory.

Quote from dbmsjob.sql:

• WHAT is the PL/SQL procedure to execute.
• The job must always be a single call to a procedure. The
• routine may take any number of hardcoded parameters.
• Special parameter values recognized are:
• job: an in parameter, the number of the current job
• next_date: in/out, the date of the next refresh
• broken: in/out, is the job broken. The IN values is FALSE. **-- Always remember the trailing semicolon. **-- Some legal values of WHAT (assuming the routines exist) are **-- 'myproc( ''10-JAN-82'', next_date, broken);' **-- 'scott.emppackage.give_raise( ''JENKINS'', 30000.00);' **-- 'dbms_job.remove( job);'

Regards,

-- 
 ===============================================================
 ! Jurij Modic                            Republic of Slovenia !
 !  tel: +386 61 178 55 14                Ministry of Finance  !
 !  fax: +386 61  21 45 84                Zupanciceva 3        !
 !  e-mail: jurij.modic_at_mf.sigov.mail.si  Ljubljana 1000       !
 ===============================================================