Home » Developer & Programmer » JDeveloper, Java & XML » To store XML in Database
To store XML in Database [message #91046] Wed, 06 March 2002 20:27 Go to next message
Jayasri
Messages: 28
Registered: July 2000
Junior Member
Hi,
Could anybody tell me how to store .xml file in the oracle database. Can this be done by using BFILE ?

Thanks
Jayasri.

Report message to a moderator

Re: To store XML in Database [message #91096 is a reply to message #91046] Wed, 03 April 2002 09:31 Go to previous messageGo to next message
Simon Jennings
Messages: 1
Registered: April 2002
Junior Member
Hi Jayasri,

You can either store it as a BFILE, or read the file contents into a CLOB (which is the data-type behind Oracle 9i's new XML Data Type).

Simon

Report message to a moderator

Re: To store XML in Database [message #91655 is a reply to message #91046] Mon, 30 December 2002 00:14 Go to previous message
san_jaym
Messages: 4
Registered: December 2002
Junior Member
use dbms_xml.save() to store data from xml file.
i m using 8i and i have not this utility.
i will be oblige if u can send me the catxsu.sql file
it is in $home/admin dir
my id is san_jaym@yahoo.com

Report message to a moderator

Previous Topic: Oracle 9i vs Oracle8i BLOB.class and CLOB.class missing
Next Topic: I need a plenty of oracle test questions, as I am preparing for OCP.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 02 02:47:35 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.