Hi,
Under Oracle APEX 24.2.11, I have created a validation which is type SELECT to test if RETOUR_API contains the word “OK” :
select RETOUR_API FROm AD_CRISE_SMS WHERE RETOUR_API LIKE'%OK%' AND ID_CRISE =:P39_ID AND RETOUR_API IS NOT NULL
Under SQL Command I get results :
RETOUR_API{"result":"OK","order_id":"12310850","total_sent":2,"internal_order_id":"7991330a-d8ed-4ff9-afbf-d108930c8556"}
But when I submit the page with a button "Envoyer_SMS, I get an error from APEX :
0,051620,00043...Validation "Pas de SMS envoyé " - Type: NOT_EXISTS4
0,052050,00077select /*+qb_name(apex$108_39)*/count(*) from sys.dual where exists (select RETOUR_API FROm AD_CRISE_SMS WHERE RETOUR_API LIKE'%OK%' AND ID_CRISE =:P39_ID AND RETOUR_API IS NOT NULL
)4
0,052810,00015......Did NOT pass4
0,052960,00027Add error onto error stack: Le SMS n'a pas pu être envoyé à cause d'une erreur.2
0,053230,00007Error: Le SMS n'a pas pu être envoyé à cause d'une erreur.
- Additional info:
- 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:
- SQL error:
- Backtrace: ----- PL/SQL Call Stack -----
object line object
handle number name
0x72fb9f5a8 1055 package body APEX_240200.WWV_FLOW_ERROR.INTERNAL_GET_ERROR
0x72fb9f5a8 1124 package body APEX_240200.WWV_FLOW_ERROR.INTERNAL_ADD_ERROR
0x72fb9f5a8 1179 package body APEX_240200.WWV_FLOW_ERROR.ADD_ERROR
0x79d5f8220 178 package body APEX_240200.WWV_FLOW_VALIDATION.PERFORM_VALIDATION.PUT_ERROR_ON_STACK
0x79d5f8220 240 package body APEX_240200.WWV_FLOW_VALIDATION.PERFORM_VALIDATION
0x79d5f8220 902 package body APEX_240200.WWV_FLOW_VALIDATION.PERFORM_CUSTOM_VALIDATIONS
0x79d5f8220 1101 package body APEX_240200.WWV_FLOW_VALIDATION.PERFORM
0x77bd9e5b0 4279 package body APEX_240200.WWV_FLOW.ACCEPT
0x776ad50c8 2 anonymous block
- Statement:
- Component: APEX_APPLICATION_PAGE_VAL Pas de SMS envoyé (1042383199652191716)1
0,053300,00003< APEX_APPLICATION_PAGE_VAL Pas de SMS envoyé3
0,053340,00002...Inline validation error count = 14
0,053360,00005...Inline Errors detected, performing rollback
I don't understand why.
Best regards.