Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_JOB schedule

Re: DBMS_JOB schedule

From: suresh manampilly via OracleMonster.com <forum_at_OracleMonster.com>
Date: Fri, 11 Feb 2005 11:13:52 GMT
Message-ID: <02ad08b5708b4aa683803fc72202bde6@OracleMonster.com>


Hi,

I tired it but I get following message:

SQL> exec dbms_job.isubmit(65,'jncdm_mexx_purfact2;',sysdate,'decode(to_char(sysdate,'DAY'),'FRIDAY' ,'trunc(sysdate + 1) + 15/24 + 00/(24 * 60)','trunc(sysdate + 1) + 13/24 + 40/(24 * 60)')'); BEGIN dbms_job.isubmit(65,'jncdm_mexx_purfact2;',sysdate,'decode(to_char(sysdate,'DAY'),'FRIDAY','tr

                                                                                  *
ERROR at line 1:
ORA-06550: line 1, column 83:
PLS-00103: Encountered the symbol "DAY" when expecting one of the following:
. ( ) , * @ % & | = - + < / > at in mod not range rem => ..
<an exponent (**)> <> or != or ~= >= <= <> and or like between is null is not || is dangling

SQL> Is there anything wrong with my syntax?

TIA Suresh

-- 
Message posted via http://www.oraclemonster.com
Received on Fri Feb 11 2005 - 05:13:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US