get XML from database

[Guest]

I have a table that has the data in XML form, (xml doc) how can i get that
XML doc from the database?

 

[darrel]

I have a table that has the data in XML form, (xml doc) how can i get that

XML doc from the database?

Are you saying you have an XML file stored as text in the DB?

-Darrel

 

[Guest]

its stored as a clob in the table

Are you saying you have an XML file stored as text in the DB?

-Darrel

 

[darrel]

its stored as a clob in the table

Hmm...no idea what a clob is. I think I'm in way over my head on this one.
I'll humbly bow out of the conversation now. ;o)

-Darrel

 

[BobRoyAce]

He probably meant a blob field.

 

[Ken Cox [Microsoft MVP]]

Is it CLOB or BLOB? This uses an image abut it might give you the idea:

HOW TO: Read and Write BLOB Data by Using ADO.NET Through ASP.NET

http://support.microsoft.com/default.aspx?scid=kb;en-us;326502