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 vote176 views1 answer
Which is the order of precedence among following operator IN OUT AND OR in sql
SQL
11 votes205 views6 answers
Mysql else if
SQL
0 vote287 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
13 votes186 views1 answer
Select count of distinct values sql
SQL
13 votes200 views4 answers
What is sql
SQL
0 vote285 views1 answer
Postgresql powershell query
SQL
1 vote179 views3 answers
Grant syntax in sql
SQL
1 vote173 views1 answer
Alphabetical order mysql
SQL
4 votes198 views6 answers
Sql select statement
SQL
3 votes175 views2 answers
Find the median in sql
SQL