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 vote302 views1 answer
Mysql query to check record exists in database table or not
SQL
16 votes277 views2 answers
Gremove folder from git
SQL
24 votes316 views5 answers
Import dump mysql
SQL
0 vote289 views1 answer
Output table plsql
SQL
3 votes286 views1 answer
Oracle user quota on tablespace
SQL
0 vote302 views1 answer
SQL Query to delete all the tables in a database
SQL
0 vote289 views1 answer
Dapper run sql script with parameters
SQL
4 votes340 views2 answers
Postgresql float data type
SQL
0 vote290 views1 answer
Postgress append string in select
SQL
1 vote236 views1 answer
Oracle compile schema
SQL