PDA

View Full Version : Does Kettle support Oracle XMLTYPE datatype?



sraju
01-22-2009, 06:34 PM
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,

sboden
01-23-2009, 02:47 AM
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