 Table Functions [message #562353] |
Tue, 31 July 2012 12:22 |
 |
naxi
Messages: 2
Registered: July 2012
|
Junior Member |
|
|
I would like to use table function in OWB mapping. Table function is inside a package and it already exists in
my database. I imported it and I am able to drag and drop it from Component Palette.
The problem I have is this:
I have a joiner JOINER_A with OUTGRP1:
TASK_DB_ID
TASK_ID
TASK_APPL_CODE
From this joiner I map TASK_APPL_CODE to my GET_APPL_RANGE table function.
TASK_APPL_CODE is a string and it is input parameter for GET_APPL_RANGE table function.
As a RETURN from GET_APPL_RANGE table function I get APPL_GROUP_ID, LOWER_APPL_CD, UPPER_APPL_CD.
Now I have result table RESULT_TABLE that has:
TASK_DB_ID,
TASK_ID
APPL_GROUP_ID
LOWER_APPL_CD,
UPPER_APPL_CD
I am trying to map(insert) TASK_DB_ID and TASK_ID from JOINER_A
and APPL_GROUP_ID, LOWER_APPL_CD, UPPER_APPL_CD from table function into RESULT_TABLE.
But I cannot do that. I get an error:
API8003: Connection target attribute group is already connected to an
incompatible data source. Use a Joiner or Set operator to join the upstream data first before connecting it into this operator.
I was thinking about another joiner between JOINER_A and GET_APPL_RANGE table function, but it doesn't make sense.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
