How to map an oracle sequence to the inputmap of a master catalog.
Article ID: KB0086545
Updated On:
| Products | Versions |
|---|---|
| TIBCO Collaborative Information Manager | - |
| Not Applicable | - |
Description
Resolution:
Steps:
1. Create an oracle function which returns the <sequnce>.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 <sequence>.nextval to the PRODUCTID for each record.
Steps:
1. Create an oracle function which returns the <sequnce>.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 <sequence>.nextval to the PRODUCTID for each record.
Issue/Introduction
How to map an oracle sequence to the inputmap of a master catalog.
Feedback
Yes
No
Powered by
