Urgent:: Use of COM/COM+ and XML data to interface Oracle DB, best practices

Hi
Good advice for how to most efficent generate XML-Data from "datasets" in an oracle database would be apriciated, the ability to use SQL-Server would be an advantage,

I need to make a set of COM/COM+ functions available as an API to distribute data in an existsing application (200/300 tables), and eventually replace the current DB-application-interface. The current implementation will be done in VB6, the intention is to eventually move to .NET and web-services. I will be using XML as the data-interface language, the intention is that the COM/ COM+ objects will be responsible for:

1. Receiving data request/manipulation commands in an XML-format, and generate and run SQL's
2. Formatting the data and returning authorized data to the user-program as an xml-string

The XML data definitions is intended to hide some of db-complexity and will in most cases span several tables, this to incorporate type definitions and information about "childs-/specialised-nodes".

Stein Received on Fri Dec 20 2002 - 10:29:10 CET