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

From: Ban Spam <ban-spam_at_operamail.com>
Date: Sat, 21 Dec 2002 21:33:12 GMT
Message-ID: <Xns92EB8A1163614SunnySD_at_68.6.19.6>


"news.online.no" <stein-a4_at_online.no> wrote in news:ZrBM9.2876$CG6.49627_at_news4.e.nsc.no:

> 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
>
>
>

If running Oracle 9i DB, take a look at DBMS_METADATA Received on Sat Dec 21 2002 - 22:33:12 CET

Original text of this message