Re: run a package on the 15th of each month.

On 9 Sep 2005 09:11:30 -0700, "jwa6" <jwagans_at_yahoo.com> wrote:

>I did this block to test. I get an error as you can see below..
>
>v_date := trunc(add_month(sysdate,1))+15+(7/48);
>
>ORA-06550: line 5, column 17:
>PLS-00201: identifier 'ADD_MONTH' must be declared

http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/functions004.htm#sthref1097

--
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool