Declare
	a boolean;
	var1 varchar2(1000);
	var varchar2(1000);
Begin
	var1:=get_block_property('vew_sponsorship_detail',default_where);
	list_values(Restrict);
	if
		:filter.country_name is not null then
		var:=var1 ||' and student_country_code='||ltrim(rtrim(:vew_sponsorship_detail.student_country_code));
	end if;
	go_block('vew_sponsorship_detail');
	clear_block;
	set_block_property ('vew_sponsorship_detail',default_where,var);
	execute_query;
	END;

SQL> desc vew_sponsorship_detail;
 Name                            Null?    Type
 ------------------------------- -------- ----
 SPONSORSHIP_CODE                NOT NULL NUMBER(5)
 CONTACT_CODE                             NUMBER(5)
 SPONSORSHIP_TYPE                         VARCHAR2(10)
 DONATION_CODE                            NUMBER
 DD_CODE                                  NUMBER
 DD_LINE_NO                               NUMBER
 DD_DETAIL_AMOUNT                         NUMBER(10,2)
 DONATION_AMOUNT                          NUMBER(5)
 SPONSORSHIP_SDATE                        DATE
 SPONSORSHIP_EDATE                        DATE
 STUDENT_COUNTRY_CODE                     NUMBER(5)
 STUDENT_NAME                             VARCHAR2(100)
 STUDENT_CODE                             NUMBER(5)
 CONTACT_NAME                             VARCHAR2(100)