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 vote229 views1 answer
Check user sql password from command line
SQL
38 votes240 views4 answers
Count sql
SQL
0 vote213 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
2 votes177 views1 answer
Sql server check for value in multiple columns
SQL
3 votes261 views1 answer
Sql add two values together
SQL
0 vote177 views1 answer
Top 3 salary in sql
SQL
1 vote163 views1 answer
Delete row mssql
SQL
12 votes167 views1 answer
How to change the value of a table in sql
SQL
0 vote197 views10 answers
John the ripper mysql
SQL
0 vote248 views1 answer
Modificar tipo de dato sql server
SQL