Skip to Content
0
Former Member
Oct 21, 2008 at 02:15 PM

XMLTYPE - Dictionary Project

19 Views

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?