topic Re: Oracle table export with varray data type in Talend Studio

Oracle table export with varray data type

Anonymous — Sat, 16 Nov 2024 05:36:44 GMT

Hi Team,

We have requirement there we need to take varray table data into csv file.In that table one column is having object data type for varray.How to fetch data if varray column type and write into a file.

Please assist.

Regards,

Vivek

Re: Oracle table export with varray data type

fdenis — Wed, 12 Jun 2019 13:00:58 GMT

can you a sample of varray in csv.

you may get it by splitting field or using document data type

Re: Oracle table export with varray data type

Anonymous — Wed, 12 Jun 2019 13:58:24 GMT

In Toracleinput we have two property i.e. TYPE and DB TYPE for type we can select 'document' but what we need to select for DB TYPE,because there is no 'document' value in drop down.

Re: Oracle table export with varray data type

fdenis — Wed, 12 Jun 2019 14:06:51 GMT

if you want to convert your array to xml you can use XMLTYPE but VARCHAR2 is good.
db type is not important. java type is.

Re: Oracle table export with varray data type

Anonymous — Thu, 13 Jun 2019 09:05:48 GMT

Got below error when selected document and varchar2 .

Execution failed : Job compile errors
At least job "Test3" has a compile errors, please fix and export again.
Error Line: 1801
Detail Message: The method getDocument(int) is undefined for the type ResultSet
There may be some other errors caused by JVM compatibility. Make sure your JVM setup is similar to the studio.

Re: Oracle table export with varray data type

fdenis — Mon, 17 Jun 2019 16:15:32 GMT

you can get your data using something like
SELECT w.*,e.*
from yourtavle w , TABLE (w.yourVarrayColumn) e
use it on your query or on a lockup with a tMap.
Regards,