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 vote291 views1 answer
VSCode SQL Server Connection error
SQL
19 votes288 views4 answers
Rename database in sql
SQL
3 votes301 views5 answers
Foreign keys
SQL
0 vote318 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
3 votes274 views1 answer
Delete all content in table mysql
SQL
2 votes316 views2 answers
Postgresql get table names
SQL
1 vote313 views1 answer
Primary key with prefix sql
SQL
0 vote284 views1 answer
Choose only one for each distinct collumn regardless of other columns
SQL
1 vote294 views1 answer
Drop function
SQL
21 votes301 views1 answer
SQL cheat sheet pdf
SQL