Hello all,
i use APEX 19.2 and want to create a generic report for some dozen tables.
I want to create the select statement for the report with a stored function , becaise there is some complexity involved but get an error
ORA-01403: no data found
during design time and can not save the page.
The function body looks like this
return betrieb.dynamic_select(pi_object_name => :P11_OBJECT_NAME, pi_database =>:P11_DATABASE);
Of course the bind variables contain no values during design time.
When I test the stored function in SQL developer. it returns always a value, even for inplausible input dates.
Any Ideas how to proceed ?
Thanks a lot
Norbert