Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
PL/SQL XML Programming
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Feb 21, 2012 9:50 AM by
Input/Output as XML for Oracle Procedure
Feb 21, 2012 9:06 AM
Please guide me or help me below
I have to write a procedure input as a XML file and do some process inside of procedure like inserts/updates oracle table or retrieve data from xml file and have to send XML file as output to that procedure.
Thanks in advance
This content has been marked as final.
Show 1 reply
Re: Input/Output as XML for Oracle Procedure
Feb 21, 2012 9:50 AM
in response to
That's a broad topic.
I suggest you first search in the forums for terms like "XML to Table", "Store XML file in Oracle", etc.
You'll find a lot of examples.
If you have issues with a
case, please post these additional details :
- database version (SELECT * FROM v$version)
- sample input XML
- tables structures
- requirement (e.g. which XML element goes to which column...)