Re: Jobno in dbms_job.submit

Check the parameter types for the submit procedures next and inteval parameters. one is date and one varchar. from memory you code should be note the extra quotation marks.

 SQL> variable jobno number;
 SQL> begin
   2 dbms_job.submit(:jobno, 'UPDINVDTW;', trunc(sysdate+1),    3 'trunc(sysdate+1+3/24)');
   4 commit;
   5 end;
   6 /

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************


"Md Irfan" <irfan_pk_at_hotmail.com> wrote in message
news:c42168e7.0206250131.7427e4bb_at_posting.google.com...
> "Jeremy Ovenden" <newsposter_at_hazelweb.co.uk> wrote in message >


> > DECLARE

> > j NUMBER;

> > BEGIN

> >

> > dbms_job.submit(j,'wd_ctx_utils.sweep;',interval=>'sysdate+1/720

> > ');

> >   dbms_output.put_line('Job# is '||j);

> > END;

> > /

>
> ************************
> Hi Jeremy
> I get the following error, the job is I would like to run every day
> (or in the next day daily) at morning 3 AM.
>
>
> SQL> variable jobno number;
> SQL> begin
>   2  dbms_job.submit(:jobno, 'UPDINVDTW;', trunc(sysdate+1),
>   3  trunc(sysdate+1+3/24));
>   4  commit;
>   5  end;
>   6  /
> begin
> *
> ERROR at line 1:
> ORA-23319: parameter value "26-JUN-02" is not appropriate
> ORA-06512: at "SYS.DBMS_JOB", line 49
> ORA-06512: at "SYS.DBMS_JOB", line 119
> ORA-06512: at line 2
>
> I also checked this Connor's solution, but didn't worked
>
>
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&th=cbead3b73506570d&rnum=
3
>
> Thanks...