Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

help with oracle xml api for pl/sql

Status
Not open for further replies.

goaway1234

Programmer
Jun 2, 2004
78
US
I'm new oracle's xml capabilities, and I'm having trouble making sense of the mountains of reference material available. I've had success with a couple of very ugly attempts, but I'm sure that I'm making this much more complicated than it needs to be.

My procedure is given an xmltype such as:
Code:
<entity_list security_uid=n>
  <entity id=1 checked=0>
  <entity id=2 checked=1>
   ...
</entity_list>

Then the procedure needs to evaluate the xpath expr "/entity_list/entity[@checked=1]/@id", then return all of the id's in a varray.

Doing this on other platforms is very straightforward because you can get a dom node list from this expression, and then iterate over it. I have not been able to find such functionality in the oracle packages. What am I missing?
 
I think that it would. What I need is functionality that I've seen in every DOM implementation I've ever used; I'm just having trouble finding it in dbms_dom. Exactly what procedure in this package allows you to evaluate xpath expressions?
 
That would be perfect, except that it doesn't exist on 9i. When I try to call it, I get a 'invalid identifier' error. Is this something that our DBA must setup?
 
a user in another forum told me that in 9i you can find this in the dbms_xslprocessor package.

Thanks, Sem, for all your advice.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top