Home » Infrastructure » Windows » Oracle provider on VB.Net returning XML
Oracle provider on VB.Net returning XML [message #112333] Thu, 24 March 2005 08:27
Messages: 1
Registered: March 2005
Location: Maryland, USA
Junior Member

How do I use the Oracle .Net provider to return a resultset in XML form?

Previously I used the Microsoft provided OLEDB library, but it does not seem to work with my database now. No errors and the result I get back is an empty data set (like my SELECT query simply excluded all rows). But when I take that same query and run it in another application I get a nice result set. So I do not think it is the query. I think for some reason my MS OLEDB provider does not communicate with the DB anymore. (maybe a patch or change on the database?).

I'd rather try the Oracle provider anyways as I've heard it is faster. I've gotten that to work just fine and return a nice result set that I was expecting.

My problem is the Oracle provider does not have a nice GetXML method like the MS OLEDB one does.

So my question is how do I get that result back in an XML form using the Oracle provider?

Jim Neff
Previous Topic: Please Help
Next Topic: Error installing Oracle 9i on Windows 2000 server
Goto Forum:

Current Time: Mon Aug 15 08:40:23 CDT 2022