Copying Oracle Table with XMLTYPE field from one DB to Another gives ORA-06553: PLS-306 error

Highlighted
Six Stars

Copying Oracle Table with XMLTYPE field from one DB to Another gives ORA-06553: PLS-306 error

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.

 

tal_1.PNGtal_2.PNGtal_3.PNGtal_4.PNG

Twelve Stars

Re: Copying Oracle Table with XMLTYPE field from one DB to Another gives ORA-06553: PLS-306 error

hi,

Did you try to use document for xml type?

 

Francois Denis

Tag as "solved" for others! Kudos to thanks!

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Downloads and Trials

Test drive Talend's enterprise products.

Downloads