Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: 15th of every month for jobs running
On Fri, 09 Sep 2005 10:39:00 -0700, jwa6 interested us by writing:
> 'trunc(add_month(sysdate,1))+15+(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