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
ruchireiki
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.
Regards,
RA
Re: XML file Synchronization [message #203027 is a reply to message #202954] Mon, 13 November 2006 10:35 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Quote:
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: Keep .doc in Database
Goto Forum:
  


Current Time: Sat Dec 03 01:08:30 CST 2016

Total time taken to generate the page: 0.08346 seconds