DevOps, CI/CD and Automation

HI

I have a doubt:

I need to receive a parameter in my report and I need this parameter in the query, that means, I need to create a dynamic query depending on the value that I receive in one of the parameters that has my report.

I tried to use the resource of Searching by Reference Cursor tool, it is a blue circle in the Data Model View of Report Builder.

When I click this tool, I have an initial code, It is:

function QR_1RefCurDS return <RefCurType> is
begin

end;


In PL/SQL I tried to create to test and to play, this code:

Note: If you want to try only to test, it is simple and works:

create or replace package TEST_REFCURTYPE as

type refcurtype is ref cursor;


function TEST_REFCURTYPE (P_DATE_TO nvarchar2) return refcurtype;

end;


create or replace package body TEST_REFCURTYPE as


function TEST_REFCURTYPE (P_DATE_TO nvarchar2)

return refcurtype is

refcur refcurtype;

mysql varchar(1000);

begin

If P_DATE_TO is not null then
mysql := 'select '''|| P_DATE_TO ||''' from dual';
else
mysql := 'select sysdate from dual';
end if;

open refcur for mysql;
return refcur;

end;

end;


The problem is to pass this example of code to the function QR_1RefCurDS, I do not have a place to make reference to the type:

type refcurtype is ref cursor;


I tested the Unit Program in the Report Builder but it did not work, because all the code I try to write and create, for example in the Event BEFORE REPORT, it opens  Funcion( ) …., and I can not make reference to the type refcurtype inside a Function( ).
Would you help me please?

Or there is another way to make a dynamic query in the Report Builder?

Sorry for my English, I am a Brazilian living in Spain.