Storing XML file in Database as BLOB

Ranch Hand

Posts: 114

posted 20 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi Everyone,

Can any one pl explain me how to store an xml file in a Oracle database using BLOB.

Thanks in Advance
Vishnu
[ May 12, 2005: Message edited by: Vishnu Munnangi ]

Jeanne Boyarsky

author & internet detective

Posts: 42173

937

I like...

posted 20 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Vishnu,
XML is character data. So you should use a CLOB rather than a BLOB. Take a look at Sun's tutorial for how to work with CLOBs.

[OCP 21 book] | [OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2

Java 8 (verified skill)
Skill verified by Jeanne Boyarsky

JUnit 5 (verified skill)
Skill verified by Jeanne Boyarsky

Avi Abrami

Ranch Hand

Posts: 1143

I like...

posted 20 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Vishnu,
Oracle works very well with XML. In case you haven't already done so, I suggest visiting the XML Technology Center at Oracle's OTN Web site.

Good Luck,
Avi.

You have to be odd to be #1 - Seuss. An odd little ad:

Clean our rivers and oceans from home

https://www.kickstarter.com/projects/paulwheaton/willow-feeders