XPath via HTTP

From: oafyuf <oafyuf_at_hotmail.com>
Date: 17 Jun 2004 06:49:50 -0700
Message-ID: <ea81924d.0406170549.5c1a8d11@posting.google.com>

Hi,
I'm having trouble getting back multiple results from 9i Release 2 over 8080.

I can get single results back OK:

http://servername:8080/oradb/SCOTT/EMP/ROW[EMPNO='7369']

brings back:

<?xml version="1.0" ?>

- <ROW>

<EMPNO>7369</EMPNO>
<ENAME>SMITH</ENAME>
<JOB>CLERK</JOB>
<MGR>7902</MGR>
<HIREDATE>17-DEC-80</HIREDATE>
<SAL>800</SAL>
<DEPTNO>20</DEPTNO>
</ROW>

...but

http://servername:8080/oradb/SCOTT/EMP/ROW[EMPNO='7369' or EMPNO='7499'] brings back:

<?xml version="1.0" ?>
<ERROR>ORA-19003: Missing XML root element name</ERROR>

.. so, obviously, I am missing the root element and would be getting back something like:

<ROW>
 ...
</ROW>
<ROW>
 ...
</ROW>

My question is how do I provide a root element?

Alternatively, can I get Oracle to pass back the raw XML (or can it just send back a string without validating any XML), so I can wrap it in a root element myself? I am issuing the HTTP request from inside a C# .NET component, so I can manipulate the XML once I get it.

Thanks,
G. Received on Thu Jun 17 2004 - 08:49:50 CDT