11 Replies Latest reply: Dec 8, 2012 5:36 AM by odie_63 RSS

    dbms_xmlgen -> create oracle type for xml  with attribute and value

      I am using the dbms_xmlgen to create my xml message and I am using the oracle TYPEs to create xml message elements.

      I need to create an element like this:
      <Emp type="name">xyz</Emp>

      I tried to create the type as below
      create type emp_t as object ( "type" "@type" )..

      But not sure how I need to define the value for this attribute.

      Please help. Thanks in advance for your help.