RE: Store XML in database - newbie question

From: BobM (BobM_at_discussions.microsoft.com)
Date: 09/16/04 

Date: Thu, 16 Sep 2004 09:13:06 -0700

If you are using Oracle you can define a column as an XMLType this will allow
you store and retrieve the XML as a column. In order to utilise this it is
necessary to download an addition ODP toolkit from Oracle to access it in
.Net. There is also the possibilty of storing the XML as part of the
relational database within Oracle although I haven't used that option yet.

"JezB" wrote:

> I'm not sure which group to post this in, so forgive me if I post to a few,
> hoping that someone can point me in the right direction.
>
> In a .NET project (probably ASP.NET but could also be rich client), I want
> to save some XML data to a database (sql-server but could also be Oracle).
> How can I do this ? I certainly cant see XmlDocument as a type available for
> columns in a database table, but perhaps it could be converted to/from a
> Binary or Text column ?
>
>
>

Relevant Pages

  • Creating XML from an Oracle DB
    ... answer to what must be a FAQ when generating XML from Oracle but I cannot ... Oracle 9.2 database using DBMS_XMLQUERY and DBMS_LOB. ... As a result the UK pound sign contained in a VARCHAR2 column on the ...
    (perl.dbi.users)
  • Re: XML in a Relational Database
    ... But i cannot use oracle because it is expensive, ... a cheap and light database. ... > Recent versions of major DBMS supports XML in a way you save each XML ... >> The focus of this application is the XML documents could be whatever. ...
    (microsoft.public.dotnet.xml)
  • Read from database, write to another database, simultaneously
    ... I am working on a simple script to read from one database (oracle) and ... chunks and drop the data to postgresql continuously. ... of the python database clients mentioned that using one thread to ... retrieve the data from the oracle database and another to insert the ...
    (comp.lang.python)
  • Re: [ Off Topic ] extracting data from a database and converting it into an XML file
    ... It works great with Oracle and MySQL databases, ... Oracle has built in support for XML already? ... If you stored your data in Oracle XML Database, ... standard 'C' and 'C++', ...
    (alt.comp.lang.learn.c-cpp)
  • Re: Limiting Large Result Sets
    ... Oracle 9i - Database ... Windows XP - OS ... I want to retrieve about 30 rows at a time. ...
    (comp.lang.java.databases)