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 vote244 views1 answer
Select from 3 tables one is empty
SQL
0 vote228 views1 answer
Create dabase postgresql
SQL
0 vote306 views1 answer
Sql query to select even numbers
SQL
0 vote266 views1 answer
Suse status MySQL
SQL
0 vote206 views1 answer
Finish transaction sql
SQL
0 vote243 views1 answer
Like and not like together in sql
SQL
0 vote273 views1 answer
Write SQL in ruby on rails
SQL
0 vote258 views1 answer
Search column name sql
SQL
0 vote248 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL
5 votes241 views3 answers
Mysql check if null or empty string
SQL