Alias for Cursor ROWS in DBMS_XMLGEN
slokamMay 21 2008 — edited May 28 2008Gurus,
I have following sample function to generate XML content
==========================================
create or replace function getxmldata
return clob is
mysql DBMS_XMLGEN.ctxHandle;
begin
mysql := DBMS_XMLGEN.newContext('
select cursor(select item_id as "@Item_Id",has_metal,has_stone from pid_item where item_id in (17)) as "ItemHeader"
from dual
');
dbms_xmlgen.setrowsettag(mysql,'ROOT');
dbms_xmlgen.setrowtag(mysql,null);
return(DBMS_XMLGEN.getXML(mysql));
end;
=======================================
When i call this function as "select getxmldata from dual". I do get following output
=======================================
<?xml version="1.0"?>
<ROOT>
<ItemHeader>
<ItemHeader_ROW Item_Id = "17">
<HAS_METAL>N</HAS_METAL>
<HAS_STONE>N</HAS_STONE>
</ItemHeader_ROW>
</ItemHeader>
</ROOT>
=======================================
I want to have Item as Tag name instead of "ItemHeader_ROW" . Can you please let me know how can get this??
Thanks
srinivas.L