Oracle sql procedure return value

CREATE PROCEDURE P_ValidateTIDIP(in_Tid IN VARCHAR2,in_IP IN VARCHAR2,outstaticip OUT VARCHAR2,outcount OUT NUMBER,outretvalue OUT NUMBER)
AS
BEGIN
select STATIC_IP into outstaticip from OP_TTER_MAPPING where TERMINAL_ID = in_Tid;
if in_IP = outstaticip then
    outretvalue:=1;
else 
    select COUNT(*) into outcount from OP_TTER_MAPPING where DYNAMIC_IP_LOW <= in_IP AND DYNAMIC_IP_HIGH >= in_IP AND TERMINAL_ID = in_Tid;
    if outcount = 1 then 
     outretvalue:=1;
    else
     outretvalue:=0;
   end if;
end if;
END;

Source: stackoverflow.com

Similar codes

1 vote343 views1 answer
Oracle nvl2
SQL
0 vote326 views4 answers
Mysql on kubernetes
SQL
0 vote298 views1 answer
Sql from null to not null
SQL
1 vote332 views1 answer
Tsql get beginning of year
SQL
0 vote435 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
0 vote331 views2 answers
Select columns from 2 tables with foreign key
SQL
0 vote340 views1 answer
How to define a non primary composite key in sql
SQL
2 votes339 views1 answer
Sql server case sensitive search
SQL
2 votes330 views1 answer
Drop all database tables oracle sql developer
SQL
0 vote322 views1 answer
Count characters of string mysql
SQL