What is the result of v_result

Question

Anyone who knows pl/sql

1. In_sender_id is given
2. V_result is an integer variable
3. Is this code working? I am checking the sender_id parameter. If this exists in table tb_white_list. If yes v_result is need to be 0. That all

https://code.sololearn.com/cID2ugonSG64/?ref=app

Answer 1

FUNCTION check_sender (in_sender_id number)
RETURN NUMBER
is
v_resultCode NUMBER := -1;
begin

-- if parameter is given
if trim(in_sender_id) is not null then

select count(1)
into v_resultCode
from tb_white_list t
where t.P_IIN = trim(in_sender_id);

if v_resultCode > 0 then
v_resultCode := 0;
end if;

end if;

return v_resultCode;

end check_sender;