Hi,
Under Oracle APEX 24.2.10, I have a form P.39 on application 108, with a region “Envoi de SMS” that I want to make read only for users that are not found in the select statement :
select B.NOM || ' ' || b.PRÉNOM D, b.ID R from APEX_APPL_ACL_USERS a, AD_BENEVOLE b WHERE APPLICATION_ID = :APP_ID AND ROLE_NAMES NOT LIKE '%Référent%'
and a.USER_NAME = b.USERNAME order by b.Nom ;
Under SQL Commands the select works and return values :
The debug page show this :
0,115270,00019Rendering region Envoi de SMS4
0,115450,00057select /*+qb_name(apex$108_39)*/count(*) from sys.dual where exists (select B.NOM || ' ' || b.PRÉNOM D, b.ID R from APEX_APPL_ACL_USERS a, AD_BENEVOLE b WHERE APPLICATION_ID = :APP_ID AND ROLE_NAMES LIKE '%Référent%'
and a.USER_NAME = b.USERNAME order by b.Nom
)4
0,116030,00052Add error onto error stack: Erreur lors du traitement de la condition.2
0,116540,00002Error: Erreur lors du traitement de la condition.
- Additional info: Contactez l'administrateur de l'application.
Les détails relatifs à cet incident sont disponibles via l'ID de débogage "1504144".
- Display location: ON_ERROR_PAGE
- Association type:
- Item name:
- Region id:
- Column alias:
- Row:
- Model instance id:
- Model record id:
- Internal error: true
- Common runtime error: false
- APEX error code: APEX.CONDITION.UNHANDLED_ERROR
- SQL code: -907
- SQL error: ORA-00907: SQL error: ORA-00907: parenthèse de droite absente
ORA-06512: à "APEX_240200.WWV_FLOW_DYNAMIC_EXEC", ligne 1626
ORA-06512: à "SYS.WWV_DBMS_SQL_APEX_240200", ligne 732
ORA-06512: à "SYS.DBMS_SYS_SQL", ligne 1458
ORA-06512: à "SYS.WWV_DBMS_SQL_APEX_240200", ligne 720
ORA-06512: à "APEX_240200.WWV_FLOW_DYNAMIC_EXEC", ligne 2096
ORA-06512: à "APEX_240200.WWV_FLOW_DYNAMIC_EXEC", ligne 1519
ORA-06512: à "APEX_240200.WWV_FLOW_DYNAMIC_EXEC", ligne 1668
ORA-06512: à "APEX_240200.WWV_FLOW_DYNAMIC_EXEC", ligne 1435
- Backtrace: ORA-06512: à "SYS.DBMS_SYS_SQL", ligne 1458
ORA-06512: à "SYS.WWV_DBMS_SQL_APEX_240200", ligne 720
ORA-06512: à "APEX_240200.WWV_FLOW_DYNAMIC_EXEC", ligne 1626
ORA-06512: à "SYS.WWV_DBMS_SQL_APEX_240200", ligne 732
ORA-06512: à "SYS.DBMS_SYS_SQL", ligne 1458
ORA-06512: à "SYS.WWV_DBMS_SQL_APEX_240200", ligne 720
ORA-06512: à "APEX_240200.WWV_FLOW_DYNAMIC_EXEC", ligne 2096
ORA-06512: à "APEX_240200.WWV_FLOW_DYNAMIC_EXEC", ligne 1519
ORA-06512: à "APEX_240200.WWV_FLOW_DYNAMIC_EXEC", ligne 1668
ORA-06512: à "APEX_240200.WWV_FLOW_DYNAMIC_EXEC", ligne 1435
ORA-06512: à "APEX_240200.WWV_FLOW_CONDITIONS", ligne 355
- Statement: select /*+qb_name(apex$108_39)*/count(*) from sys.dual where exists (select B.NOM || ' ' || b.PRÉNOM D, b.ID R from APEX_APPL_ACL_USERS a, AD_BENEVOLE b WHERE APPLICATION_ID = :APP_ID AND ROLE_NAMES LIKE '%Référent%'
and a.USER_NAME = b.USERNAME order by b.Nom
)
- Component: APEX_APPLICATION_PAGE_REGIONS Envoi de SMS (1515959982481816422)
Best regards.