OraFAQ Forum: JDeveloper, Java & XML » inserting xml file into oracle database table

Home » Developer & Programmer » JDeveloper, Java & XML » inserting xml file into oracle database table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

inserting xml file into oracle database table [message #325813]

Mon, 09 June 2008 00:43

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

Report message to a moderator

Re: inserting xml file into oracle database table [message #325817 is a reply to message #325813]

Mon, 09 June 2008 00:53

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

thread_Oracle wrote on Sun, 08 June 2008 22:43

huh?

Report message to a moderator

Re: inserting xml file into oracle database table [message #325821 is a reply to message #325813]

Mon, 09 June 2008 01:36

Michel Cadot
Messages: 68771
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: inserting xml file into oracle database table [message #325822 is a reply to message #325813]

Mon, 09 June 2008 01:38

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

Report message to a moderator

Re: inserting xml file into oracle database table [message #338062 is a reply to message #325813]

Sat, 02 August 2008 21:49

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

Report message to a moderator

Previous Topic:	XML Parsing Query Problem
Next Topic:	how to call java from stored procedure?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 29 05:06:44 CST 2025