Skip to Main Content

SQL & PL/SQL

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-06552: PL/SQL: Statement ignored ORA-06553: PLS-382: expression is of w

mrnewbieNov 24 2010 — edited Nov 24 2010
I am new to Oracle:

I have simple function Is_Empty for checking length of a variable:

create or replace function Is_Empty(p in VARCHAR2) return boolean
as
begin
if length(p) = 0 then
return true;
else
return false;
end if;
end;


select is_empty('xxx') from dual;

when it ran .. I got the following error message:

ORA-06552: PL/SQL: Statement ignored ORA-06553: PLS-382: expression is of wrong type

What I missed?

please help

thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 22 2010
Added on Nov 24 2010
1 comment
3,268 views