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 vote154 views1 answer
T-sql disable system versioning
SQL
2 votes137 views1 answer
Mysql select random id from table
SQL
0 vote125 views1 answer
Materialized view redshift
SQL
23 votes145 views6 answers
Create table sql server
SQL
-1 vote140 views1 answer
Condition in orderby mysql
SQL
1 vote136 views3 answers
Error 1451 (23000): cannot delete or update a parent row: a foreign key constraint fails
SQL
16 votes149 views1 answer
Mssql int max value
SQL
2 votes152 views2 answers
How to run postgresql in linux
SQL
20 votes147 views1 answer
Sql change column types
SQL
2 votes149 views1 answer
Oracle list grants on procedure
SQL