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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Writing XML document to database via Stored Procedure

Status
Not open for further replies.
Apr 10, 2006
5
US
I've read some articles about XDB and XMLTYPE for Oracle 9i, and found one where you can parse static xml code in the Stored Procedure to write into a database table, but what I really want to find is a simple example of parsing an existing XML document inside an Oracle 9i Stored Procedure, then iterating through it and writing to a table. If anyone can show me how to do this I'd be very grateful.

Thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top