ORA-01741: illegal zero-length identifier
TekuDec 27 2007 — edited Feb 26 2008Hi 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.