Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Does Kettle support Oracle XMLTYPE datatype?

  1. #1
    Join Date
    Dec 2008
    Posts
    12

    Default Does Kettle support Oracle XMLTYPE datatype?

    Hi Everyone,

    i need to execute following SQL statement in Kettle through Table input step.

    SELECT
    SYS_XMLAGG (
    XMLELEMENT(
    "DEPT",
    XMLFOREST(
    d.deptno,
    d.dname,
    d.loc,
    (
    SELECT SYS_XMLAGG(
    XMLELEMENT(
    "EMP",
    XMLFOREST(
    e.empno,
    e.ename,
    e.sal
    )
    )
    )
    FROM emp e
    WHERE e.deptno = d.deptno
    )
    "EMP_LIST"

    )
    )
    )
    FROM
    dept d

    WHERE d.deptno = 10

    i triend with SQL*Plus environment it executing fine but when i triedn with Kettle it's not giving any output.

    Does Kettle support Oracle XMLTYPE datatype?

    Please help me in this.

    Thanks,


  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Please in the specific PDI/Kettle forums... and no it doesn't support XML as type, you can use xml types in your SQL as long as they don't get exported in the select list.

    Regards,
    Sven

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.