Skip to main content

Posts

Showing posts from March, 2017

Fixing Skillbuilders Super LOV (v3) in APEX 5.1

We have already migrated some of the existing applications to a new version of Oracle Application Express - 5.1. After few weeks in production I can just say...do it :). But when doing an upgrade there is always a possibility that you will hit some issues. For me one of the issue was Skillbuilders Super LOV (v3), and it looks like I'm not alone ( https://community.oracle.com/thread/4010580 ) So what is the issue?  When you select a value (Super LOV item) and try to save a form then the value is not submitted. Now if you are lucky, then your item is mandatory and you will see the error - end users will tell you right away that something is not working. If your item is not mandatory then you might see this error much later, with complaints that some data is not saved correctly. Value is selected After submit, value is cleared and we see an error After a bit of research I have found a quick fix, that you can use, until the plugin is fixed by original authors. Wh

Using APIs to set Application and Build Status in Oracle Application Express 5.1

In Oracle Application Express it is possible to specify application-level attributes: Build Status and Application Status. With Build Status we can prevent that an application is being modified by other developers. With Application Status we can specify whether an application is available or unavailable for use. Topic of this blog post is not to talk in detail about this two attributes (if you want to know more, then check the  official documentation ), but to mention how we can use APIs to manage this attributes in Oracle Application Express 5.1 Build Status For setting build status we can use the following procedure:   apex_util.set_app_build_status(       p_application_id IN NUMBER,      p_build_status IN VARCHAR2); For p_build_status we can specify RUN_ONLY  and RUN_AND_BUILD .  More details about this API can be found here . Application Status For changing the status of the application, we can use the following procedure:   apex_util.set_applica