I am using Oracle Apex 19.2. I am trying to build a a dynamic report based on Classic report and PL/SQL function body returning SQL statement. Simply I have two date pickers where I set a default value of sysdate - 21
(set through dynamic action on page refresh) then I construct a simple report with the following PL/SQL
declare
clsd_snc date:= :P5_CLOSED_SINCE;
ignrd_snc date := :P5_IGNORED_SINCE;
begin
return 'select ' || clsd_snc || ',' || ignrd_snc || ' from dual';
end;
I have two problems:
12/15/2019
.000495049504950495049504950495049504950495
I tried using to_date and to_char in the PL/SQL and to change the date format of the pickers but nothing is working. I would hugely appreciate your help.
Thank you for the sample page. I copied your page 3 to page 4 (so that your "original" remains intact) and did this:
12/15/2019
issuereport query: enclose clsd_snc
into single quotes (chr(39)
)
this fixes the .000495049504950
issue
declare
clsd_snc date := :P4_CLSD_SINCE;
begin
return 'select ' || chr(39) || clsd_snc || chr(39) || ' from dual';
end;
I guess that's it; so - check page #4.