[bug]: "ORA-06592: CASE not found while executing CASE statement" on Page 37 - configuration-statistics

[joglakab]

Flows for APEX version

Current Development

Oracle Database version

23c

Oracle APEX version

newer

Have you used the BPMN-Linter in Flow Designer to Validate your Diagram?

No

What happened?

While saving configuration in Flows for APEX-App in Page 37 the error: "ORA-06592: CASE not found while executing CASE statement" occures.

Solution: Wrong content of "Set Settings"-procedure.

Steps to reproduce

1. Open Page 37 - configuration-statistics
2. Click on Apply Changes button (with or without changing values in on of the fields).
3. Error occures.

Expected behaviour

The fields: P37_STATS_RETAIN_DAILY P37_STATS_RETAIN_MONTH P37_STATS_RETAIN_QTR should be saved.

Solution: Wrong content of "Set Settings"-procedure (PL/SQL)

PLSQL Content should be:

flow_engine_app_api.set_statictis_settings( pi_stats_retain_daily => :P37_STATS_RETAIN_DAILY , pi_stats_retain_month => :P37_STATS_RETAIN_MONTH , pi_stats_retain_qtr => :P37_STATS_RETAIN_QTR );

Wrong PLSQL Content:

flow_engine_app_api.set_timers_settings( pi_timer_max_cycles => :P37_TIMER_MAX_CYCLES , pi_timer_status => :P37_TIMER_STATUS , pi_timer_repeat_interval => :P37_TIMER_REPEAT_INTERVAL );