On 7/26/2010 2:47 PM, Craigsell wrote: > If you are doing the insert inside the Oracle stored procedure, then you > have to commit inside the stored procedure. I have evolved into setting up > a general exception process so that if, for some reason, a stored procedure > fails, it can call a rollback and send some sort of a status message back to > the CFC or whatever called the stored proc. 11g should be no different. > > If you want some simple examples of that work on 10g and CF8, let me know > and I'll put something together and post it. > > Warren
At this time, the Insert is done with a simple <cfquery...> call BEFORE the <cfstoredproc...> call. That is the way the stored procedure was created over a decade ago. For the first phase of this project, we are only updating the application server level of this process. It waits for a future phase to tackle the stored procedures in the database level. And let me tell you that is a project we both desire and dread. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335737 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
