I want to see if I can use Talend DI to copy from records from one Oracle DB to another (and then deleting the records from the source). This should run every five seconds or so
Basically, I'm trying to automate the
SELECT * FROM TABLE FOR UPDATE
The tables on both databases are similar in every way and have only 2 fields each:
RECID - VARCHAR
XMLRECORD - XMLTYPE
I used the DBInput and DBOutput components to define the input and output tables but when I run the job I get this error:
ORA-06553: PLS-306: wrong number or types of arguments in call to 'XMLTYPE'
I'm aware of the option to use the extract function to get specific fields out of the xml field. However, I want to copy the entire field as is. As in just dump data from one table to another.
I've attached my job definitions below.
Did you try to use document for xml type?
Tag as "solved" for others! Kudos to thanks!
Try Talend Cloud free for 30 days.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.