APEX

Hi Friends,

I am facing a weird situation while creating a report with region having type as SQL Query(PL/SQL function body returning SQL Query).

I have a package function which takes 4 parameters and returns a SQL query in a varchar2 variable.

Now when I have the following code in my region source and on applying changes is showing ORA-01741: illegal zero-length identifier

DECLARE
l_query VARCHAR2 (5000);
BEGIN
SELECT apx_dashboard_pkg.f_int_monthly_grid (:p5_1, :p5_2, :p5_3, :p5_4)
INTO l_query
FROM DUAL;
RETURN l_query;
END;

If I change my code as below by passing values and run, then it does the job perfect.

DECLARE
l_query VARCHAR2 (5000);
BEGIN
SELECT apx_dashboard_pkg.f_int_monthly_grid(200712,
'IC',
3,
'AVARO'
)
INTO l_query
FROM DUAL;
RETURN l_query;
END;

I have no clue where I am doing wrong.
Please help me.

Thanks,
Raj.