How to map an oracle sequence to the inputmap of a master catalog.

How to map an oracle sequence to the inputmap of a master catalog.

book

Article ID: KB0086545

calendar_today

Updated On:

Products Versions
TIBCO Collaborative Information Manager -
Not Applicable -

Description

Resolution:
Steps:

1. Create an oracle function which returns the &ltsequnce>.nextval in the database. Eg:

function test_seq return number is
v_num number;
begin
select MQ_SEQUENCE_1.NEXTVAL into v_num from dual;
return v_num;
end;

2. In the inputmap for the master catalog, in the PRODUCTID field, call the oracle fuction, test_seq().

This will map the &ltsequence>.nextval to the PRODUCTID for each record.

Issue/Introduction

How to map an oracle sequence to the inputmap of a master catalog.
Powered by Wolken Software