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

2 votes211 views1 answer
Get hour from date sql
SQL
0 vote203 views2 answers
Plsql regex match whole word
SQL
1 vote201 views1 answer
Get last week data in mysql
SQL
0 vote312 views1 answer
Mysql multiple group by
SQL
0 vote265 views1 answer
Pl sql round
SQL
1 vote209 views1 answer
Get create table query existing table mysql
SQL
0 vote204 views1 answer
How to fetch unique records from two tables
SQL
8 votes229 views1 answer
Mysql restore database
SQL
2 votes202 views2 answers
Function in sql
SQL
17 votes331 views4 answers
Show all tables in oracle
SQL