I am trying to create a Dictionary project and I have a field which stores an XML value. In our current external oracle database the sql is this:
CREATE TABLE "PORTAL"."TBL_RSS"
(RSS_CODE VARCHAR2(20) NOT NULL ENABLE
,RSS_URL VARCHAR2(500)
,RSS_FEED "SYS"."XMLTYPE"
,RSS_LAST_REFRESH DATE
,RSS_ERROR VARCHAR2(1000)
)
How can I re-create the RSS_FEED field in a Dictionary project? I cannot find the "SYS"."XMLTYPE" as an option. Is there a better way to store this field or do I need to add references to the project?