if  :system.mode='ENTER-QUERY' then 
     set_block_property('block_name',default_where,make_search_str);
 end if;                                                                                
 EXECUTE_QUERY(NO_VALIDATE);

FUNCTION [b]make_search_str [/b]RETURN char IS
str varchar2(1000);
BEGIN

if :number_item  is not null then                                                      
   str:=str || ' col1='||:number_item ||' and';                                                          
end if;                                                                                
if :NAME is not null then   
   str:=str ||'  name like ''%' ||:name  ||'%'' and';                                                     
end if;                                                                                
str=substr(str,1,length(str)-3);                                                                             
return(str);
END;