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 vote193 views1 answer
Delete data from database sqlite android
SQL
0 vote312 views1 answer
How to update random rows in sql
SQL
3 votes191 views1 answer
Select nextval from sequence sql
SQL
0 vote183 views1 answer
Date diff sql
SQL
1 vote196 views1 answer
Rows to comma separated values in mssql
SQL
0 vote223 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
1 vote243 views1 answer
Sql where max date
SQL
3 votes203 views2 answers
Host is not allowed to connect to this mysql server
SQL
0 vote194 views1 answer
Adding primery key constraint to a column
SQL
1 vote197 views3 answers
Reset sql primary key
SQL