XMLTYPE Column type in ORacle 9i
Posted: Fri Jun 16, 2006 10:58 am
Hi,
I am using Oracle9i and datstage 7.5
I want to read a table . The structure is like
COMPANY_NAME VARCHAR2(100 BYTE),
VISIT_DATE DATE,
REPORT SYS.XMLTYPE
When I try to read in datastage, I get Unknown Column type for SYS.XMLTYPE. This happens when I try to load the column definition for this table in the ORacle OCi stage.
What datatype should I associate for this?
Thks
Ketfos
I am using Oracle9i and datstage 7.5
I want to read a table . The structure is like
COMPANY_NAME VARCHAR2(100 BYTE),
VISIT_DATE DATE,
REPORT SYS.XMLTYPE
When I try to read in datastage, I get Unknown Column type for SYS.XMLTYPE. This happens when I try to load the column definition for this table in the ORacle OCi stage.
What datatype should I associate for this?
Thks
Ketfos