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.

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.