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 vote206 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
1 vote216 views1 answer
Mysql current running queries
SQL
0 vote197 views1 answer
Create new table pl sql
SQL
0 vote213 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
0 vote197 views1 answer
Not equal to blank in mysql
SQL
0 vote218 views2 answers
PostgreSQL having
SQL
0 vote221 views1 answer
SQL Cut part string
SQL
0 vote215 views1 answer
Wordpress delete post revisions older than date "sql"
SQL
1 vote192 views1 answer
How to delete record sql delphi
SQL
27 votes259 views3 answers
Mysql delete row
SQL