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

2 votes149 views1 answer
Mysql last 7 days including today
SQL
0 vote193 views1 answer
Sql select without column name
SQL
2 votes203 views5 answers
Install postgresql 10 centos 7
SQL
0 vote233 views1 answer
Install ms sql server management studio
SQL
0 vote146 views1 answer
Inserting data into different tables at once in oracle sql
SQL
4 votes173 views2 answers
SELECT table_name FROM user_tables;
SQL
0 vote162 views1 answer
Look at running processes redshift
SQL
0 vote172 views1 answer
Connecting mySQL to STS
SQL
57 votes651 views6 answers
Sql alter table
SQL
0 vote146 views2 answers
Pop sql insert value into
SQL