Search
 
SCRIPT & CODE EXAMPLE
 

SQL

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;
Comment

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;
Comment

PREVIOUS NEXT
Code Example
Sql :: mysql order by list 
Sql :: sql division operator 
Sql :: sql is null or empty 
Sql :: search from comma separated values in sql server 
Sql :: ignore duplicate rows in sqlite 
Sql :: joining tables in sql 
Sql :: sql update from one table to another based on a id match 
Sql :: arithmetic expression in sql 
Sql :: sql 
Sql :: add column mysql 
Sql :: les jointures sql server 
Sql :: quit mysql 
Sql :: get last date join sql 
Sql :: group_concat sql server 
Sql :: is not null sql 
Sql :: aliasing in sql 
Sql :: insert update sql server 
Sql :: postgresql replace html tags from string 
Sql :: accessing varchar array from sql 
Sql :: rasa mysql connection custom actions example 
Sql :: recursive query herarchical data sql server 
Sql :: search starting with mysql 
Sql :: how to set up service broker in sql server 
Sql :: Limiting a left join to returning one result? 
Sql :: sqlalchemy database uri 
Sql :: least spark sql 
Sql :: update multiple columns in postgres 
Sql :: java check if something is in mysql table 
Sql :: unpdate pl sql 
Sql :: mode sql course 
ADD CONTENT
Topic
Content
Source link
Name
3+6 =