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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:335736 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
