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 vote111 views1 answer
Sql not equal multiple columns
SQL
0 vote129 views1 answer
How to create a table based on another table in mysql
SQL
0 vote113 views2 answers
Update all columns in one update
SQL
0 vote126 views3 answers
Duplicate row mysql
SQL
-1 vote109 views1 answer
Add column alter table default value
SQL
0 vote123 views1 answer
Select place default lat long
SQL
1 vote141 views1 answer
Mysql return text after a final full stop
SQL
0 vote119 views1 answer
Oracle allow space to user
SQL
0 vote239 views1 answer
Multiple row join
SQL
1 vote187 views1 answer
Aqua Data studio postgresql ssl
SQL