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
XMLTYPE Column type in ORacle 9i
Moderators: chulett, rschirm, roy
Re: XMLTYPE Column type in ORacle 9i
Varchar or long varchar should work.ketfos wrote: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
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.