>- see footer for list info -< I am with Adrian, just encapsulate it in a stored procedure, really much better!
On Dec 11, 2007 2:31 PM, Adrian Lynch <[EMAIL PROTECTED]> wrote: > >- see footer for list info -< > I'm not greate with Oracle, but can you not just run it as a stored > procedure? > > Adrian > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Philip Porter > Sent: 11 December 2007 14:10 > To: [email protected] > Subject: [CF-Dev] SQL batch/script processing > > > >- see footer for list info -< > Hi Guys > > I've been asked today to figure out a way to run a oracle sql script > via coldfusion. > > The script contains multiple statements of inserts, updates, creating > tables, running cursors etc (also contains commits; and /* notes */) > > At present i'm loading the script(s) and processing them best I can to > split them up into statment parts so as to run them through CFQUERY. > This is a very nasty way of doing it, and whilst it does work, its far > to bespoke to rely on, ie if someone changes the any of the scripts it > might break the code. > > So.. I'm looking for away to execute the scripts via coldfuision. > I've googled and not come up with that much so far. > > 1. either find out if the jdbc oracle thin driver supports some > parameter to allow multiple statments (like can be done with mysql) > > 2. use java to connect to the db and then use 'executebatch'? > > Any thoughts on this? > > Phil Porter > > > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go to > http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- > >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< > >- Lists hosted by www.Gradwell.com -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< > -- Simon Baynes www.simonbaynes.com LinkedIn profile:- http://www.linkedin.com/in/simonbaynes _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
