help with oracle xml api for pl/sql

[goaway1234]

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:

<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?

 

[sem]

How about xmldom package? Why doesn't it suit you?

Regards, Dima

http://seminihin.narod.ru

 

[goaway1234]

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?

 

[sem]

Try xpath.valueOf function

Regards, Dima

http://seminihin.narod.ru

 

[goaway1234]

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?

 

[goaway1234]

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.