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 vote253 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
0 vote273 views1 answer
Hierarchal database table
SQL
15 votes230 views5 answers
Show tables in oracle
SQL
1 vote227 views2 answers
Sql server add time to date
SQL
0 vote220 views1 answer
Postgresql using reserved word as column name
SQL
2 votes206 views1 answer
Check isolation level in mysql
SQL
0 vote305 views1 answer
Delet all record statment sql
SQL
1 vote234 views1 answer
Postgresql export output table as a csv
SQL
0 vote208 views1 answer
Sql get user account
SQL
0 vote226 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL