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 vote210 views1 answer
Suse start MySQL
SQL
0 vote233 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
0 vote223 views1 answer
Jooq replace
SQL
1 vote193 views1 answer
Database run
SQL
4 votes183 views3 answers
Create table if not exists postgresql
SQL
0 vote187 views1 answer
Create bakupd database sqlserver
SQL
0 vote255 views2 answers
Mysql insert into multiple tables
SQL
1 vote244 views2 answers
Foreign key set 0
SQL
0 vote223 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL
0 vote221 views1 answer
Oracle free up space in tablespace
SQL