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 vote274 views2 answers
Sql if empty then
SQL
0 vote293 views1 answer
Timestamp(0) postgresql
SQL
3 votes276 views1 answer
Sql server version query
SQL
-1 vote267 views1 answer
Io
SQL
0 vote300 views2 answers
Start mysql server using docker
SQL
0 vote282 views1 answer
How to read the potentail error messages in ssis package
SQL
19 votes295 views6 answers
Mysql if null
SQL
1 vote292 views2 answers
Oracle difference between two dates in seconds
SQL
6 votes292 views2 answers
Psql load dump
SQL
1 vote282 views1 answer
Get parameter value in mysql trigger
SQL