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 vote283 views1 answer
Oracle check table lock
SQL
0 vote258 views2 answers
Find lowest number in sql
SQL
3 votes304 views2 answers
Truncate table
SQL
34 votes282 views5 answers
Oracle alter table add column
SQL
0 vote280 views1 answer
Primary key multiple colums
SQL
0 vote273 views2 answers
Sql last updated
SQL
0 vote297 views2 answers
Temp tables in sql server
SQL
4 votes245 views2 answers
Oracle unliock account
SQL
0 vote270 views1 answer
Ms sql database data size
SQL
0 vote267 views1 answer
How to drop a trigger in postgresql
SQL