| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help with PL/SQL and XmlType
On 3 Jun 2005 00:23:35 -0700, "stork" <tbandrow_at_mightyware.com> wrote:
>
>
>TJB replied to what Lewis C wrote:
>
><snip>
>
>Thank you very much. What I'm ultimately trying to do is map an XPATH
>query to some sort of a vector so that I can subsequently insert or
>update into a normal table. I would like ideally to map an XPath query
>to a table and then insert into in a bulk way (or use merge), but even
>if I have to loop through a sequence of query results and do insert, it
>would be a heck of a lot better than passing a bunch of arrays to proc
>to mimic "recordness".
You may be doing more work than you need to. I would need specific details to make a specific recomendation but check out DBMS_XMLSave, DBMS_XMLStore or possibly DBMS_XMLDOM. Some good stuff there.
Thanks,
Lewis
Author, ItToolBox Blog: An Expert's Guide to Oracle http://blogs.ittoolbox.com/oracle/guide/
Topic Editor, Suite101.com: Oracle Database http://www.suite101.com/welcome.cfm/oracle
Sign up for courses here:
http://www.suite101.com/suiteu/default.cfm/416752
 |
 |