ORA-06512 when I put JOB_DBMS.INTERVAL

From: <mtn_bikers_at_msn.com>
Date: 27 Mar 2006 06:38:09 -0800
Message-ID: <1143470289.920522.140430@t31g2000cwb.googlegroups.com>

When I try to put a JOB interval in Oracle I have an error ORA-06512. I'd like to put an interval once a week (saturday). I try with this command but it dosen't work.

---

SQL> next_day(sysdate,'TUESDAY')
SP2-0734: unknown command beginning "next_day(s..." - rest of line ignored.
SQL> exec DBMS_JOB.INTERVAL(1,next_day(sysdate,'WEDNESDAY')); BEGIN DBMS_JOB.INTERVAL(1,next_day(sysdate,'WEDNESDAY')); END;

*
ERROR at line 1:

ORA-23319: parameter value "29-MAR-06" is not appropriate
ORA-06512: at "SYS.DBMS_JOB", line 57
ORA-06512: at "SYS.DBMS_JOB", line 230
ORA-06512: at line 1


----------------------------------------------------------------------------------------------------------------------

Someone have ideas?

Thanks. Received on Mon Mar 27 2006 - 08:38:09 CST