Re: Creating a XML file

From: Anna C. Dent <anacedent_at_hotmail.com>
Date: Wed, 12 May 2004 17:04:16 -0700
Message-ID: <1Yyoc.124053$Jy3.46695@fed1read03>

the spammers have won :-( wrote:
> Anna C. Dent wrote:
>

>> Robert Scheer wrote:
>>
>>> I need to create a trigger that when raised, creates a XML file
>>> reflecting all the data of a table. I can do that using SQL Server but
>>> I am fairly new to Oracle. My Oracle version is 8.1.7.
>>
>>
>> Time to RTFM(s)
>>
>> http://otn.oracle.com/pls/db92/db92.drilldown?remark=&word=dbms_xml&book=&preference= 

>
>
>
> Anna,
> I was just wondering why you referred Robert to the documentation
> for Oracle 9.2, when he clearly states that he is using 8.1.7?
>
> Good Luck,
> Avi.

Avi,
Why did you not ask the OP what was lacking in the V8.1.7 docset?

When our 3rd party V8.1.7 application needed XML support, but the vendor was not yet ready to "certify" V92, we found ourselves in a bind. My solution was to put up a V9.2 DB, deposit into it some homebrew packages which could be called from the V8.1.7 DB. The XML support in V9.2 is far, far superior to what is available in V8.1.7 DB. I suspect there is little from precluding Robert from doing something similar to what I did because it would be a DB strictly under his control and not restricted by any external applications.

Sometime you need to think outside the box to get useful results. Received on Wed May 12 2004 - 19:04:16 CDT