Variable declaration

exec :pt_no := '88888888'; 
   select *
     from ACPPRICD
    where PT_NO = :pt_no ; 

 
 define in_pt_no = '88888888'
   select *
     from ACPPRICD
    where PT_NO = &&in_pt_no; 
    
    
var x refcursor ; 
exec  PKG_ORDER.SELECTDRUGLIST('', '' ,'811', '1', 'I' ,'Y', '', '', '001000', '1',:x )