Hi Team,
Tested on apex.oracle.com & local instance on 24.2.2. This happens when the Template Directive is incorrectly stated.
Steps to reproduce;
- Shared Components > Plugins > Create > Next
- Name = HelloWorld
Available As = Single
Partial = <span class="fa {if #COLUMN#/}fa-check{else/}fa-times{endif/}"></span>
- Click Create Plug-in
This results in ORA-02290: check constraint (APEX_240200.PLUGIN_ATTR_STATIC_ID_CK) violated
The problem is that #COLUMN# should not be wrapped in #'s within a Template Directive; but the error message is confusing to the developer.
It also happens if the Synchronize from Templates button is pressed when the Partial contains the above HTML
https://apex.oracle.com/pls/apex/r/apex_pm/ut/template-directives