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

1 vote339 views1 answer
Declare variables sql
SQL
0 vote328 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
0 vote352 views3 answers
Postgresql grant alter table to user
SQL
0 vote410 views2 answers
Remove mysql workbench ubuntu
SQL
0 vote345 views1 answer
Luu ckeditor vao mysql
SQL
0 vote355 views1 answer
Sqlite löschen einer tabelle
SQL
0 vote356 views1 answer
List all indexes postgres
SQL
5 votes368 views2 answers
Postgres update with if condition query
SQL
0 vote330 views1 answer
Including parameters in OPENQUERY
SQL
0 vote354 views1 answer
Formatting code with SQL Developer
SQL