get path to nodes by value

754085

can't save the values into record based table???

754085

If I make object, then it's not saves into package but into type folder. I want all in one place!

ravikumar.sv

you can do it...but it's a bit tedious to execute....
and the worst thing is you cannot call a function inside a query(as I shown in the last statement of above post) to obtain data, if you define return types to be pl/sql record types,so better they be sql types.

and also this will be easy method to access data for an input xml...
just a simple query needs to be run ...
instead of running a pl/sql block, retrieving the data,copying into local variables and looping on that data.

Ravi Kumar

754085

But I Don't need from sql get these values in the end. I need this list to replace values from databases and do some work with xml , update it and then return xmltype like blob into database.

MichaelS

this is simpler...

Right. Should simply have searched a bit more intensively to find path-to-node