topic Importing Oracle Schema with inbuilt TYPE in Talend Studio

Importing Oracle Schema with inbuilt TYPE

stucas — Sat, 16 Nov 2024 02:44:21 GMT

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.

Re: Importing Oracle Schema with inbuilt TYPE

akumar2301 — Fri, 10 Apr 2020 14:41:03 GMT

If you are ok to use tOracleRow :
https://community.talend.com/t5/Design-and-Development/Nested-table-Data-reterival-with-TOracleInput/td-p/158394

Re: Importing Oracle Schema with inbuilt TYPE

akumar2301 — Fri, 10 Apr 2020 14:42:49 GMT

Try record parser like mentioned in this link

https://community.talend.com/t5/Design-and-Development/tOracleSP-returning-a-RECORD-TYPE/td-p/22426