selecting check box inside database block

declare
lvar_lableId varchar2(20);
lnum_recCount number;
begin
[Quoted] select count(*) into lnum_recCount from file_name; select decode(:chk_all,1,'Clear All','Select All') into lvar_lableId from dual;
set_item_property('chk_all',PROMPT_TEXT ,lvar_lableId); first_record;
:file_name.chk_selectfile := :chk_all;

for i in 1..lnum_recCount loop
next_record;
:file_name.chk_selectfile := :chk_all;

end loop;
end;

The above code is used to select all the check boxii in the database block by selecting 1 'Select All' check box. But it is not checked/unchecked correctly.

Where am i wrong?
Please guide me!!!

--
Posted via http://dbforums.com