Adam, 1) Even with the same username/password, oracle treats it as two sessions. If you have TOAD you can verify this with the session browser.
2) stored procs don't change the transaction handling of oracle (unless, or course, you manually commit within the body of the proc) - ie cf handles cfstoredproc just like cfquery: by default it will commit after each </cfstoredprocedure> unless you use <cftransaction>. /t >-----Original Message----- Subject: FW: Get New Record ID in ORACLE >From: Adrocknaphobia <[EMAIL PROTECTED]> >Date: Wed, 8 Jun 2005 10:52:48 -0400 >Thread: >http://www.houseoffusion.com/cf_lists/index.cfm/method=messages >&threadid=40594&forumid=4#208966 > >James, > >Interesting test. This strongly contradicts what our DBAs have been >telling me. I'm going to bring this up with them. (I love when they >are proved wrong!). The only thing is that you are using only a single >session. ie. same user to perfrom both actions since I'm assuming u/p >is hardcoded into your DSN. Although you get all sorts of errors with >cftransaction if they aren't hardcoded. > >What about with stored procedures? I think the second a procedure is >completed and returned the commit is automatically applied, regardless >of the cftransaction. So is it safe to say that cftransaction should >only be used with cfquery and not cfstoredproc? > >-Adam ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208981 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
