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

5 votes110 views3 answers
MySql get fields of table
SQL
0 vote115 views3 answers
Mysql keyword search
SQL
1 vote105 views2 answers
Sql server add time to date
SQL
13 votes107 views2 answers
Sqlite rename table
SQL
25 votes108 views3 answers
Mysql command show tables
SQL
0 vote122 views1 answer
To Create directory
SQL
0 vote142 views1 answer
AddEntityFrameworkSqlite
SQL
6 votes112 views1 answer
Oracle rank
SQL
0 vote115 views1 answer
Mysql get first 2 characters of string
SQL
5 votes107 views2 answers
Mysql import gzip db
SQL