0

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.

1
Contributor
1
Reply
2
Views
9 Years
Discussion Span
Last Post by avtar.sohi
0

hi friends,
i understand my mistake.
DATEADD function doesn't exist in oracle, that is why i m geting that exception.
Tx lot.
Avatr.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.