Hi,
Under Oracle APEX 24.2.11, I try to check on the form P.11 if the length of the ITEM P11_PRINCIPALE_COMPÉTENCE type text contains at least 10 characters.
The validation is the following and is accepeted on the page designer :
LENGTH (TO_NUMBER(:P11_PRINCIPALE_COMPÉTENCE)) > 9);
But at runtime of the page, I get an error :
ORA-06512: à "APEX_240200.WWV_FLOW_VALIDATION", ligne 1101
- Statement: begin wwv_flow.g_boolean := LENGTH (TO_NUMBER(:P11_PRINCIPALE_COMPÉTENCE)) > 9)
;
Best regards.