Re: DBMS_JOB!

 have an extra ' at the begining of the 3rd parameter(sysdate) try removing that

• Arvind Tina Tran wrote:

> I tried to sumbit a job to dbms_job as:
> dbms_job.isubmit(1,'my_procedure_name','sysdate)
>
> but I got this error instead:
> ORA-01858: a non-numeric character was found where a numeric was expected
> ORA-06512: at "SYS.DBMS_JOB", line 104
> ORA-06512: at line 1
>
> Anyone knows what is wrong?

--
Balaraman Arvind
151 Andrew Ave, Apt 215
Naugatuck, CT 06770

ph   -  (203)-723-1190(R)
     -  (203)-459-7502(O)

mail -  dnivra_at_ix.netcom.com (R)
        abalaram_at_oxhp.com    (O)