Hi, I am trying to generate an XML. Below is a sample code from my function. The function generates a 0 byte file which when I try to open gives me 'xml document must have a top level element' error. Any ideas?
FUNCTION generateXml( p_1 VARCHAR2,
p_2 VARCHAR2,
p_3 VARCHAR2
) RETURN CLOB
IS
ctx dbms_xmlgen.ctxHandle;
xml CLOB;
v_sql varchar2(2000);
BEGIN
lv_sql:=' select * from v_dc where rownum =1';
ctx := dbms_xmlgen.newContext(v_sql);
dbms_xmlgen.setRowSetTag(ctx, 'CONTENT');
xml := dbms_xmlgen.getXML(ctx);
return xml;
END;
END generateXml;