Recent content by S8chem

That did it. Thanks for the help.

The query is: SELECT XMLELEMENT ( "Emp", XMLATTRIBUTES (e.id,e.fname | |' ' | | e.lname AS "name")) AS "result" FROM employees e The employee table defines 3 fields: lname, fname and id.

I get this error OCI:21500 when running a query that will return results formatted as XML. The target database is Oracle 9i. Using SQL+ I can get the information I need although it appears without the XML formatting. Is there a patch or workaround for getting this functionality to work with...