Oracle XML Help.

[pavendan]

When i try to form xml structure using DBMS_XMLQuery.GetXML, for one particular query it gives the following error:
"oracle.xml.sql.OracleXMLSQLException: The row enclosing tag or the row-set enclosing tag is ommitted; consequently to get a well formed XML document, the result can only consist of a single row with multiple columns or multiple rows with exactly one column each."

Any info on why this problem occurs?

 

[Guest_imported]

Have you tried this:

DBMS_XMLQuery.setRowSetTag(<queryContext>, <rowSetTag>);
DBMS_XMLQuery.setRowTag(<queryContext>, <rowSetTag>);

This will set your row set and row tags for the query context.