>- 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 -<
