Home » SQL & PL/SQL » SQL & PL/SQL » All the Oracle Scripts in Single XML File
All the Oracle Scripts in Single XML File [message #418653] Tue, 18 August 2009 00:23 Go to next message
Hemanth123
Messages: 56
Registered: April 2009
Member
Hi,

I was told to merge all the Oracle Scripts which I have written(Tables,Views,Alter Scripts,Functions,Triggers,Packages) into a single XML file as it would be easy for the DOT NET frame work to execute all the scripts at once.

The reason I was told is that instead of maintaining so many scripts and execute each one(of course as a batch file at one time)
why can't be it done in a single file.

Please let me know whether is it a good idea to merge all the scripts into a single file of XML type and if it is could any one give me a sample script so that it would be helpful for me.

Thanks in Advance,
Hemanth
Re: All the Oracle Scripts in Single XML File [message #418660 is a reply to message #418653] Tue, 18 August 2009 00:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
How is this a SQL or PL/SQL question?

Regards
Michel
Re: All the Oracle Scripts in Single XML File [message #418661 is a reply to message #418653] Tue, 18 August 2009 00:53 Go to previous messageGo to next message
Prajakta001
Messages: 52
Registered: June 2008
Location: Mumbai
Member

Hi ,

Don't have much idea about xml file and executing the db scripts .net framework.
I prefer to have sql file/s. You can make a single sql file for all the scripts (Tables,Views,Alter Scripts,Functions,Triggers,Packages) which you can run from sql prompt.

It would be easy to make out the execution error/s if any while running the scripts from sql prompt.

( may be this the only way I am aware)

Regards
Prajakta
Re: All the Oracle Scripts in Single XML File [message #418695 is a reply to message #418653] Tue, 18 August 2009 03:31 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I'd reply that the maintenance required would not be reduced by putting al the scripts into a single piece of XML - rather it would increase as it would be harder to find each individual piece of code, and harder to test each change made in isolation.

Re: All the Oracle Scripts in Single XML File [message #418702 is a reply to message #418653] Tue, 18 August 2009 03:47 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
If your .Net developers need the scripts in XML and they are unable to generate that from your scripts, I would not trust them to either run or maintain them anyway..
Re: All the Oracle Scripts in Single XML File [message #418739 is a reply to message #418702] Tue, 18 August 2009 07:42 Go to previous message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Also, if they just told you the need "an XML file" without any specification on how that XML file should look, then there is not much you can do without asking them for that definition first anyway.

Previous Topic: exception with select query
Next Topic: Compare query speed
Goto Forum:
  


Current Time: Sat Feb 15 17:14:54 CST 2025