Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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 (3)
2 Replies
akumar2301
Specialist II
Specialist II