Hi,
Under APEX Version=24.2.9, on page 3 of Application 110, I have an error message on a form when I submit it:
ORA error message: ORA-01402: vue WITH CHECK OPTION - violation de clause WHERE :
Error: ORA-01402: vue WITH CHECK OPTION - violation de clause WHERE
0,16340-Error: ORA-01402: vue WITH CHECK OPTION - violation de clause WHERE
- Additional info: ORA-01402: vue WITH CHECK OPTION - violation de clause WHERE
- Display location: INLINE_IN_NOTIFICATION
- Association type:
- Item name:
- Region id:
- Column alias:
- Row:
- Model instance id:
- Model record id:
- Internal error: false
- Common runtime error: false
- APEX error code:
- SQL code: -1402
- SQL error: ORA-01402: vue WITH CHECK OPTION - violation de clause WHERE
- Backtrace:
- Statement: (select * from "AD_BENEVOLE"where(USERNAME IS NULL
)
with check option)
- Component: APEX_APPLICATION_PAGE_PROCESS Traiter le panneau Bénévole (30615839500741747)
I am not doing any insert statement on this view APEX_APPL_ACL_USERS which is an APEX build-in view. I am only selecting data from this view (select USER_NAME….) on other pages. Before it worked but now it raise this error on page 3 when I create the record on the table AD_BENEVOLE with a DML treatment.
It is when the form is doing a DML treatement of the form on the table AD_BENEVOLE, not any insert is made on the column of the view APEX_APPL_ACL_USERS.
Best regards.