Home » Developer & Programmer » JDeveloper, Java & XML » inserting xml file into oracle database table
inserting xml file into oracle database table [message #325813] Mon, 09 June 2008 00:43 Go to next message
thread_Oracle
Messages: 4
Registered: June 2008
Junior Member
i have a xml file
<?xml version="1.0" encoding="UTF-8"?>
<orcl>
<Payment>
<TNumber>1</TNumber>
<cnumber>123</cnumber>
<chg>
<chgnum>1234</chgnum>
<pl>G</pl>
<pty>v</pty>
<pa>1</pa>
</chg>
</Payment>
</orcl>

like this above way my xml file will be there i need to insert data in the database table how can i do it. please help me
Re: inserting xml file into oracle database table [message #325817 is a reply to message #325813] Mon, 09 June 2008 00:53 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
thread_Oracle wrote on Sun, 08 June 2008 22:43
i have a xml file
<?xml version="1.0" encoding="UTF-8"?>
<orcl>
<Payment>
<TNumber>1</TNumber>
<cnumber>123</cnumber>
<chg>
<chgnum>1234</chgnum>
<pl>G</pl>
<pty>v</pty>
<pa>1</pa>
</chg>
</Payment>
</orcl>

like this above way my xml file will be there i need to insert data in the database table how can i do it. please help me

huh?
Re: inserting xml file into oracle database table [message #325821 is a reply to message #325813] Mon, 09 June 2008 01:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.orafaq.com/forum/?SQ=8fc5a5a1123e8cfa63ed8152cdde6519&t=search&srch=insert+xml+into+table&btn_submit=Search&am p;field=all&forum_limiter=&search_logic=AND&sort_order=DESC&author=

Regards
Michel
Re: inserting xml file into oracle database table [message #325822 is a reply to message #325813] Mon, 09 June 2008 01:38 Go to previous messageGo to next message
fortunethiyagu
Messages: 94
Registered: December 2006
Member

Please be clear with your query ..

what do you want to do?

1) Want to insert data and have to generate XML file? or
2) want to insert a XML file in certain column?

for both u need to use clob as datatype. For 1st one have to use TO_CLOB function to convert the content into CLOB values. For 2nd you can directly insert XML file in a CLOB datatype column.

Let me know your question properly.

thiyagarajan palanisamy
Re: inserting xml file into oracle database table [message #338062 is a reply to message #325813] Sat, 02 August 2008 21:49 Go to previous message
Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA
Senior Member
is anyone else getting tired of it?...

Easy XML - Let the Database do the Work

Easy XML - a Programming Oriented Approach

Kevin Meade's blog

Good luck, Kevin
Previous Topic: XML Parsing Query Problem
Next Topic: how to call java from stored procedure?
Goto Forum:
  


Current Time: Fri Mar 29 08:07:49 CDT 2024