This discussion is archived
11 Replies Latest reply: Dec 8, 2012 3:36 AM by odie_63 RSS

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

978547 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points