Oracle table export with varray data type

[Anonymous]

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

[fdenis]

can you a sample of varray in csv.

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

[Anonymous]

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.

[fdenis]

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.

[Anonymous]

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.

[fdenis]

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,