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 vote316 views2 answers
Imageview setimageresource null
SQL
1 vote295 views2 answers
String to date postgres
SQL
0 vote302 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
0 vote362 views1 answer
Mssql last day of month
SQL
0 vote322 views1 answer
Asp.net core sql server stored procedure
SQL
0 vote307 views1 answer
Android sqlite add column if not exists
SQL
0 vote299 views1 answer
Can we rollback data that are deleted using DELETE
SQL
0 vote320 views1 answer
Search mysql database for column
SQL
0 vote307 views1 answer
Mysql drop vs delete
SQL
1 vote303 views1 answer
Oracle finding duplicate records
SQL