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 vote122 views1 answer
What is the difference between now() and current_date()?
SQL
0 vote134 views1 answer
Implicit inner join table alias
SQL
0 vote118 views1 answer
Restore backup "text" postgresql command line
SQL
7 votes143 views1 answer
Return insert results in POSTGRESQL
SQL
5 votes129 views3 answers
Oracle first day of last year
SQL
1 vote129 views1 answer
Second last highest id in sql
SQL
16 votes126 views1 answer
Mssql int max value
SQL
0 vote121 views1 answer
Why we have to set the password for my sql server
SQL
3 votes164 views2 answers
@sqlresultsetmapping
SQL
0 vote254 views1 answer
Sql change a colum to unique
SQL