Re: XPath via HTTP

OK, I eventually dug the answer out of Oracle's documentation myself... and present it here in the interest of helping any other poor newbies on Oracle's Xpath implementation over HTTP:

http://servername:8080/oradb/SCOTT/EMP/ROW[EMPNO='7369' or EMPNO='7499']?rowsettag=YOUR_ARBITRARY_ROOT_NAME

oafyuf_at_hotmail.com (oafyuf) wrote in message news:<ea81924d.0406170549.5c1a8d11_at_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 Fri Jun 18 2004 - 04:53:18 CDT