[Solved] My PL/SQL code is not working:

by 


CREATE OR REPLACE PROCEDURE log(repname in varchar2) AS    
PACKAGE_NAME VARCHAR2,-- give size here like varchar2(50) 
START_TIME DATE,    
END_TIME DATE,   
STATUS;

BEGIN

 SELECT 
PACKAGE_NAME ,
PRCS_START_TIME ,
PRCS_END_TIME,
STATUS

-- add into clause to assign selected --values in variables 

FROM CONTCL_OWNER.PROCESSLOG    
WHERE PACKAGE_NAME LIKE '%REPNAME%' 
And ROW_NUMBER <=7   ORDER BY PRCS_START_TIME ; 
END;

solved My PL/SQL code is not working: