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

1 vote115 views1 answer
Change table to innodb mysql
SQL
0 vote105 views1 answer
An exception occurred while executing a transact-sql statement or batch user,group or role already
SQL
0 vote108 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
1 vote114 views1 answer
Select from describe sql
SQL
12 votes113 views6 answers
Select distinct
SQL
0 vote117 views1 answer
How to take sum of column with same id in "JPQL?"
SQL
1 vote108 views2 answers
Sql convert datetime to year month
SQL
0 vote123 views1 answer
Sql bild in function
SQL
0 vote107 views1 answer
Transaction database with php
SQL
18 votes111 views6 answers
Create table mysql
SQL