APEX

I have a a query which (amongst others) is returning a column that is either 'Y' or NULL. I also have a comments field which I can enter text into a textbox. The column returning the Y/NULL flag is created as a checkbox in the report using apex_item.checkbox(20, etc etc).

Now, I have a "save changes" button which when clicked I want to call a plsql function, passing in values from the form. When I do this however I am getting an error "No Data Found".

BEGIN
  FOR i IN 1..apex_application.g_f01.count LOOP
    packagename.procedureName(
      pkey_1 => apex_application.g_f01(i),
      pval_2 => apex_application.g_f02(i),
      pval_3 => apex_application.g_f03(i),
      pval_4 => apex_application.g_f04(i)
    );
  END LOOP;
END;

I believe it is because some of the checkboxes are not checked, however I want to pass null to the function in this case. Am I correct in thinking that arrays apex_application.g_fxx only contain non-null values?

When the report runs, I need the existing value of the flag to set the checkbox (ie, if on the database the value is 'Y' then this should be reflected in the report) - this currently works so I cannot lose this functionality.


Is there any way I can stop this error?


Thanks in advance! :)