>- see footer for list info -< Not sure of your exact requriement, but with SQL Server I use CFQUERY
In theory, the content between the CFQUERY tags needs to be valid SQL as per your datasource. So essentially: - - you could read the script file into a variable - enclose variable between cfquery tags - run Only issue is you will only ever get back one resultset. alternatively, place script as SP and call accordingly. On 11/12/2007, 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 > -< > _______________________________________________ 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 -<
