Hi,
I'm getting the following error when i try to access the element value in the row of a tabular form/report.
ORA-01403: no data found
I have a row selector added to the form and created a process with the following code (simplified):
DECLARE
vRow BINARY_INTEGER;
BEGIN
:P41_SELECTEDROWS := NULL;
FOR i IN 1 .. apex_application.g_f01.COUNT LOOP
vRow := apex_application.g_f01(i);
if apex_application.g_f03(vRow) is not null then
:P41_SELECTEDROWS := :P41_SELECTEDROWS ||' '|| apex_application.g_f03(vRow);
end if;
END;
The odd thing is, if I changed 3 to a 1 in "apex_application.g_f03(vRow)" in the code, it works else it will give me the above error. The tabular form has 8 columns.
I would greatly appreciate your help!
Thanks,
Marilyn