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

Home -> Community -> Usenet -> c.d.o.misc -> Re: 15th of every month for jobs running

Re: 15th of every month for jobs running

From: HansF <News.Hans_at_telus.net>
Date: Fri, 09 Sep 2005 17:48:02 GMT
Message-Id: <pan.2005.09.09.17.52.26.9092@telus.net>


On Fri, 09 Sep 2005 10:39:00 -0700, jwa6 interested us by writing:

> 'trunc(add_month(sysdate,1))+1­5+(7/48)'
> end;
>
>
> ORA-06550: line 5, column 17:
> PLS-00201: identifier 'ADD_MONTH' must be declared
> ORA-06550: line 5, column 1:
> PL/SQL: Statement ignored

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10759/functions004.htm#sthref1072

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***
Received on Fri Sep 09 2005 - 12:48:02 CDT

Original text of this message

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