Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01741: illegal zero-length identifier

TekuDec 27 2007 — edited Feb 26 2008
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 25 2008
Added on Dec 27 2007
4 comments
11,867 views