search

flowsforapex / apex-flowsforapex

Flows for APEX - Model and run process flows all within Oracle APEX!
https://flowsforapex.org
Other
81 stars 41 forks source link

[bug]: Error in flow_log_admin causes supporting objects install to fail with database 23c #676

Closed rallen2010 closed 12 months ago

rallen2010 commented 1 year ago

Flows for APEX version

23.1 (latest)

Oracle Database version

23c

Oracle APEX version

23.1

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

Yes

What happened?

During installation, flow_log_admin is installed as part of the supporting objects.

There is an error on line 56 

 ‘businessID’   value prov.prov.prov_var_vc2,

should read

 ‘businessID’   value prov.prov_var_vc2,

Apparently database 19c isn't worried by this & the query runs as it was intended. But 23c is stricter & compilation of the package body fails. This causes installation to fail on db 23c.

Workaround: After completing the install, go to APEX > Data Workshop > Packages. You should see that the flow_log_admin package is highlighted because it contains an error. Make the change above by removing the prov. then recompile and you should be OK.

But note there are currently other issues running on 23c and so this is not supported.

Steps to reproduce

No response

Expected behaviour

Already fixed in dev.

rallen2010 commented 12 months ago

Hotfix file combo-fix-675-676-681.sql available as a Release 23.1 asset at https://github.com/flowsforapex/apex-flowsforapex/releases/tag/v23.1 addresses this issue and provides support for Oracle Database 23c (23.3.0).