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 vote189 views1 answer
Where not in array sql
SQL
3 votes181 views2 answers
Sql select data from last week
SQL
1 vote187 views1 answer
Add many column to sap iq table
SQL
2 votes171 views1 answer
Oracle apex list connected users
SQL
0 vote206 views1 answer
Add week ending date sql server
SQL
0 vote184 views1 answer
Tsql delete all rows
SQL
0 vote202 views3 answers
Call to undefined function mysql_connect()
SQL
0 vote175 views1 answer
Inner join distinct
SQL
0 vote209 views1 answer
Pgadmin check database
SQL
0 vote169 views1 answer
Sql remove decimal places
SQL