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 vote150 views1 answer
Mysql update sum same table
SQL
4 votes146 views1 answer
Oracle session date format
SQL
0 vote161 views1 answer
Query by column for substring sql
SQL
2 votes155 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
0 vote160 views1 answer
New rails app with mysql
SQL
8 votes151 views4 answers
Mysql update one table from another table multiple columns
SQL
-2 votes161 views1 answer
How to open database
SQL
0 vote163 views1 answer
Oracle table free space
SQL
0 vote140 views1 answer
Dasebase_url-postgres for windows
SQL
5 votes173 views3 answers
Select tables from mysql database
SQL