Hi
I am using Talend Studio (7.3.1) and importing a schema for a table for which one column is of a custom type: ABL_TYPE
This is defined as:
create or replace TYPE "ABL_NAME_ELEMENT_TYPE" AS OBJECT (
name VARCHAR2(50),
len NUMBER,
used CHAR,
part_type CHAR);
When the schema is import Talend is unable to determine the DB Type (it's empty). If I try to override it with object, raw or dynamic the best I can get is "Oracle.sql.ARRAY@86589" output. I've also tried trying to alter the Oracle data mapping XML file.
Only 2 days into trying to get my head around this so this exercise (tOracleInput to tDelimitedFile) is one of understanding - so I'm just trying to understand what I think is in effect a Java object serialisation issue?
Any help gratefully appreciated.