Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

APEX 24.2 Template Component ORA-02290: check constraint (APEX_240200.PLUGIN_ATTR_STATIC_ID_CK) violated

Matt MulvaneyFeb 24 2025

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;

  1. Shared Components > Plugins > Create > Next
  2. Name = HelloWorld
    Available As = Single
    Partial = <span class="fa {if #COLUMN#/}fa-check{else/}fa-times{endif/}"></span>
  3. 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

Comments

Post Details

Added on Feb 24 2025
0 comments
46 views