Hi ,
I am compiling this package.
I get the foll errorCode: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; /
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




Reply With Quote