Home » SQL & PL/SQL » SQL & PL/SQL » XML file Synchronization
XML file Synchronization [message #202954] Mon, 13 November 2006 07:21 Go to next message
Messages: 3
Registered: October 2006
Junior Member
Hi All,
I have created an XML file from a table in oracle. Now, the requirement is, to update the file as soon as any DML occurs in the respective table.
Does anyone have an idea how to implement it??
One way culd b to create trigger on the possible DMLs over the table..and write code to regenerate the file on occurance of that event. Is ther any other efiifcient way ?????
I m using Oracle 10gR1 on Win XP.
Thx in advance for the help.
Re: XML file Synchronization [message #203027 is a reply to message #202954] Mon, 13 November 2006 10:35 Go to previous message
Messages: 7880
Registered: March 2000
Senior Member
One way culd b to create trigger on the possible DMLs over the table..

Another (more sane) way would be to question the requirement. Why would you want to replicate a perfectly good database into an XML-file?

[Edit: typo]

[Updated on: Mon, 13 November 2006 10:35]

Report message to a moderator

Previous Topic: Cant see the Table Name..
Next Topic: devide a full name of a person into 4 seperate names
Goto Forum:

Current Time: Sat Aug 19 13:55:04 CDT 2017

Total time taken to generate the page: 0.08504 seconds