APEX

Hi

Under APEX 24 I have a validation. It works well on SQL commands. But at runtime an error message is displayed :

“Error during treatment of validation” :

select 1
 from ve_reservation
where date_reservation = TO_DATE(:P10_DATE_RESERVATION, 'DD/MM/YYYY')
  and exists (
      select 1
        from ve_reservation
       where date_reservation = TO_DATE(:P10_DATE_RESERVATION, 'DD/MM/YYYY')
       group by date_reservation
       having count(*) < 20
    )
  and rownum = 1;

Best regards.