err: identifier 'DATEADD' must be declared

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 374,005 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,778 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Oracle advertiser:

Thread Tools Display Modes

Views: 822 | Replies: 1 | Solved

•

Join Date: May 2008

Posts: 6

Reputation: avtar.sohi is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

avtar.sohi avtar.sohi is offline

Offline

Newbie Poster

err: identifier 'DATEADD' must be declared

May 5th, 2008

Hi friends,
i got this err while executing this procedure.
err is like this:-
-----------------------------------------------------------------------------
9/3 PL/SQL: Statement ignored
9/13 PLS-00201: identifier 'DATEADD' must be declared
11/3 PL/SQL: Statement ignored
11/13 PLS-00201: identifier 'DATEADD' must be declared
------------------------------------------------------------------------------
Please have look my stored procedure
CREATE OR REPLACE PROCEDURE GReptExprtCompliTestRelt(EntityFolderCode number,
RangeStartDate date,
RangeEndDate date,c1 OUT SYS_REFCURSOR)
AS
rStartDate date;
rEndDate date;
tempDate date;
BEGIN
tempDate:=DATEADD(dd,1,RangeEndDate);
rStartDate:= UPPER(RangeStartDate);
tempDate:=DATEADD('ss',-1,tempDate);
rEndDate:= UPPER(tempDate);
OPEN c1 FOR
select * from t;
end;
/

hey i m using rstartdate and renddate in my procedure, i m not giving here all those code, i have writen this procedur just to get solution of my problem, so don't bother that where i m using rstartdate and renddate variable, hope you all understand my problem,
thanks lot.
Avtar.