Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
stucas
Contributor
Contributor

Importing Oracle Schema with inbuilt TYPE

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.
Labels (4)
2 Replies
akumar2301
Specialist II
Specialist II