DEBUG A FUNCTION RETURNING BOOLEAN / ORACLE XE
515325Jan 4 2007 — edited Jan 8 2007HI guys,
how can i debug the following function in pl/sql developer?
I really can't see what is wrong?
CREATE OR REPLACE
function TAUTH (p_username in varchar2)
return boolean
is
begin
return TRUE;
end;
This is what is used by pl/sql developer
DECLARE
P_USERNAME VARCHAR2(200);
v_Return BOOLEAN;
BEGIN
P_USERNAME := NULL;
v_Return := TAUTH(
P_USERNAME => P_USERNAME
);
DBMS_OUTPUT.PUT_LINE('v_Return = ' || v_Return);
END;