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 vote179 views2 answers
Sqlite
SQL
4 votes185 views1 answer
Mac install mysql
SQL
1 vote166 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
3 votes178 views1 answer
Sql server version query
SQL
25 votes198 views5 answers
Uninstall mysql ubuntu
SQL
6 votes259 views1 answer
How to count number of rows in sql
SQL
0 vote210 views1 answer
What is common table expression in sql
SQL
13 votes194 views4 answers
Command line mysql import
SQL
0 vote181 views1 answer
Call object contructor and call methods of object
SQL
0 vote139 views1 answer
Check id exist or not in sql
SQL