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;