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

0 vote316 views0 answer
SQL
0 vote393 views1 answer
Sql to excel pgadmin
SQL
0 vote314 views1 answer
Postgresql import data from csv
SQL
1 vote355 views1 answer
Mysql add fields
SQL
3 votes364 views1 answer
Oracle list privileges
SQL
0 vote322 views6 answers
Unique key in sql
SQL
0 vote326 views1 answer
Select top 3 sql
SQL
1 vote369 views1 answer
Mysql connect bash
SQL
0 vote379 views1 answer
How to inner join 4 tables in sql
SQL
0 vote344 views1 answer
How to search query in python3 sqlite3
SQL