Re: dbms_job and the 'what'

Hi

Try this:

    create or replace foo(p_char in varchar2) is     v_jobno number;
    begin
    dbms_job.submit(v_jobno,

          'dummy_job('||p_char||');',
   sysdate + .0007,
   NULL,
   FALSE);
    commit;
    end foo;

regards
Kai Received on Wed Feb 23 2000 - 08:13:33 CST