PLS-00103: Encountered the symbol "end-of-file" in a PAckage
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: PLS-00103: Encountered the symbol "end-of-file" in a PAckage

Threaded View

  1. #1
    Join Date
    Apr 2005
    Posts
    5

    PLS-00103: Encountered the symbol "end-of-file" in a PAckage

    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
    Last edited by gandolf989; 04-28-2005 at 11:03 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width