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
What are the aggregate function in sql
SQL
1 vote194 views1 answer
Declare variables sql
SQL
20 votes215 views3 answers
How to open postgresql in mac
SQL
2 votes189 views1 answer
Pandas to sql index
SQL
0 vote189 views1 answer
Getting next sequence value jpa postgress
SQL
0 vote194 views1 answer
Postgres truncate with cascade
SQL
0 vote193 views1 answer
Oracle search columns in schema
SQL
0 vote200 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
9 votes197 views4 answers
Oracle get table column names
SQL
2 votes196 views2 answers
Checking data type in sql server
SQL