Xml-Input Stage Processes only one Oracle CLOB at time
Posted: Fri Mar 30, 2012 12:50 am
Hi,
I have a source system which stores XML message in Oracle database as CLOB. I'm trying to read the CLOB messages and loading them into another table in tabular form columns.
To acheive it - am reading data from Oracle connector and processing them as XML Data through XML Input Stage. Now the issue here is - If I've 10 CLOB Messages in Database, Orale Connector reads all 10 but XML Input Stage processes only one CLOB and ignores others.
Can any one point where am going wrong? Do you people think it's job design issue or any setup issue, at job level?
Kindly suggest your ideas.
Thanks - Anusha
I have a source system which stores XML message in Oracle database as CLOB. I'm trying to read the CLOB messages and loading them into another table in tabular form columns.
To acheive it - am reading data from Oracle connector and processing them as XML Data through XML Input Stage. Now the issue here is - If I've 10 CLOB Messages in Database, Orale Connector reads all 10 but XML Input Stage processes only one CLOB and ignores others.
Can any one point where am going wrong? Do you people think it's job design issue or any setup issue, at job level?
Kindly suggest your ideas.
Thanks - Anusha