On Mon, 3 Mar 2003 09:42:51 -0800 Fernando Luna <[EMAIL PROTECTED]> wrote:
> It would have been nice to know if, say, someone had worked out > something to process SQL files since this is such a common task and > developers who don't use perl but work with Oracle frequently use SQL > files. Bulk creation of tables, and other database objects is probably better left in SQL files; especially since they will probably have to be maintained by people who aren't familiar with Perl. I think dbish and SQL Minus (?) are supposed to be able to handle some of the things you are talking about, but I would consider it unlikely that they would be able to follow all twists and turns that Oracle may allow in SQL*Plus syntax. > Having worked with SQL*Plus and Oracle for many years now, I am quite > familiar with it's limitations and its nature. I am not so gullible as > to presume that other tools understand sqlplus syntax. Just because DBI is an excellent hammer doesn't mean every problem is a nail. Use whichever works better for the particular task. > > -----Original Message----- > > From: M Addlework [mailto:[EMAIL PROTECTED] > > Sent: Thursday, February 27, 2003 10:16 AM > > To: Fernando Luna > > Cc: [EMAIL PROTECTED] > > Subject: RE: Running SQL from files - was: Your DBI book > > I suggest you step way back and ask yourself various key questions, > > such as: > > > > - who controls the source code that is the input to your module? > > - what control do you have over them? > > - what do you _really_ need to accomplish here? > > (especially in light of the fact that you have a working > > shell-script solution, no?) > > > > The gist is that unless you can exert complete control over the > > sql source code, you will be taking on a potentially endless hassle > > because if the programmers generating the source are writing for > > sqlplus, you will have to effectively implement a sqlplus emulator. > > > > What's the point? You will spend a _lot_ of time, and how will the > > end result be different (better) from your current solution? I'm not > > saying it can't be better, but rather saying that you should have > > a very clearly identified and defined objective of what exactly > > that added value will be, and ask yourself if it will be worth the > > price, and/or if there isn't some simpler way to add that value. -- Mac :}) ** I normally forward private questions to the appropriate mail list. ** Ask Smarter: http://www.catb.org/~esr/faqs/smart-questions.html Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age.
