Hi all,
we have an application written in apex 4.2 where we have a page containing a tabular form with a validation on data, type: Function body (returning error text)
Tabular form source query:
select ID_PROCESS,
TICKET_NUM_PROBLEM,
QUESTION,
dbms_lob.substr(ANSWER,4000,1) ANSWER
from PROCESS_QUESTIONNAIRE
where ticket_num_problem=replace(:P86_TICKET_NUM_PROBLEM,'=',':')
Validation source code:
DECLARE
sid_chk varchar2(40); sid_hidden varchar2(500);
tmp boolean default true; n_riga integer;
BEGIN
FOR i IN 1 .. apex_application.g_f01.COUNT
LOOP
sid_hidden:=apex_application.g_f01(i);
if sid_hidden is null then
tmp := false;
n_riga := i;
end if;
end loop;
if tmp then
return null;
else
return 'Please fill all fields';
end if;
END;
The problem is that when importing the application in apex 20.2, everything is OK, but importing in apex 21.2.1 , when validation fires and shows the error 'Please fill all fields', the page tries to re-display the tabular forms giving the following error:
report error:
ORA-20001: Error fetching column value: ORA-01403: no data found
Looking into debug log , the code is the following:
Any help would be appreciated :)
Max