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 vote195 views1 answer
Oracle rolling back transactions
SQL
1 vote394 views3 answers
Create table from existing table in sql
SQL
0 vote185 views1 answer
PG::ForeignKeyViolation: ERROR: update or delete on table violates foreign key constraint
SQL
1 vote196 views2 answers
Mysql join two tables
SQL
0 vote194 views1 answer
Sql server remove enter from string
SQL
0 vote201 views1 answer
Kill slow queries mysql
SQL
1 vote186 views2 answers
Mysql order by date asc null last
SQL
0 vote154 views2 answers
Sql query unique
SQL
0 vote382 views1 answer
Multiple row join
SQL
3 votes204 views2 answers
Sql select data from last week
SQL