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 vote146 views1 answer
How to order result of subquery in select
SQL
34 votes142 views6 answers
Sql change data type
SQL
1 vote175 views1 answer
Sql in array query
SQL
3 votes144 views3 answers
Sql last week
SQL
22 votes180 views1 answer
Mysql workbench
SQL
1 vote148 views1 answer
Mysql list bigger table
SQL
0 vote154 views1 answer
Adding generated time in row mysql workbench
SQL
0 vote168 views1 answer
Get only structure database mysql
SQL
0 vote131 views2 answers
How to start postgresql laravel
SQL
0 vote143 views1 answer
Pl sql constraint user function
SQL