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 vote376 views1 answer
Vs 2019 connect to local mysql database
SQL
0 vote346 views1 answer
Difference between varchar and varchar2
SQL
1 vote345 views1 answer
Add sequence postgres
SQL
4 votes380 views2 answers
Truncate oracle
SQL
0 vote366 views1 answer
Sql query to find duplicate email address
SQL
0 vote365 views4 answers
How to connect form to database
SQL
2 votes311 views2 answers
Mysql get last character of string
SQL
0 vote373 views1 answer
Find usage of table in sql server
SQL
3 votes366 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL
0 vote393 views1 answer
Sql commands in android
SQL