Hi ,
I am compiling this package.
Code:
CREATE OR REPLACE PACKAGE BODY Calendar_LastYrStatistics IS
PROCEDURE LastYr_Statistics(pProperty In Varchar2,
pThisDate In Date,
pOccupied Out Number,
pSameDay Out Number) IS
vFromDate Date;
BEGIN
vFromDate:=Add_Months(pThisDate,-12);
BEGIN
select Occupied,SameDay
into pOccupied, pSameDay
from Daily_Stat
where Property = pProperty
and ThisDate = vFromDate;
END;
Exception
WHEN OTHERS then
pOccupied:=NULL;
:=NULL;
END;
/
I get the foll error
PLS-00103: Encountered the symbol "end-of-file" when expecting
one of the following:
begin end function package pragma procedure form
Can someone please help me ?..
Thanks