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

4 votes214 views1 answer
How to check last gather stats on table in oracle
SQL
16 votes192 views1 answer
Mssql int max value
SQL
0 vote185 views1 answer
Default password for mysql_secure_installation in mac
SQL
2 votes182 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
0 vote192 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
1 vote177 views1 answer
Sysdate in sql
SQL
14 votes1.2K views1 answer
Sql value of string
SQL
0 vote171 views1 answer
Copy value from one column to another postgres
SQL
1 vote171 views1 answer
Sql run multiple updates in one query
SQL
0 vote175 views1 answer
Sql server update top n records
SQL