Hi Guys,
I have one issue that have been bugging me for the past 2 days. I'm curious why I cannot execute the following query using APEX SQL Command when it actually running fine in TOAD.
select day_of_month dt
from
(select (level - 1) + trunc(to_date(:P1_MONTH||:P1_YEAR,'MMYYYY'),'MM') day_of_month
from dual
connect by level <= 31)
where day_of_month < add_months(trunc(to_date(:P1_MONTH||:P1_YEAR,'MMYYYY'),'MM'),1)
As a result, I cannot create new form or report using SQL query that contained the above lines and ended up getting 'the connection was reset' error message.
For your info, I'm using Oracle Database 12c and Oracle APEX 19.1.0.00.1
Please advise. Thanks.