encounter error PLS-00382: expression is of wrong type
Hi -
Can someone please help me? I've created a function and was trying to compile this:
FUNCTION val_star_item (i_segment1 IN VARCHAR2,
i_description IN VARCHAR2)
RETURN BOOLEAN
IS
v_star BOOLEAN;
BEGIN
IF i_segment1 = i_description THEN
return('Y');
ELSE
return('N');
END IF;
END val_star_item;
But I've encountered this error:
LINE/COL ERROR
-------- -----------------------------------------------------------------
322/9 PL/SQL: Statement ignored
322/15 PLS-00382: expression is of wrong type
324/11 PL/SQL: Statement ignored
324/17 PLS-00382: expression is of wrong type
Input truncated to 1 characters
And it's referring I think to this part of my code: i_segment1=i_description. My objective here is to compare what ever value I had for those parameters. If both are the same then return Y if not then return N.
Thank you