Good points. It seems to be an ORACLE thing. You can make the Global Temporary table either transaction or session specific using the ON COMMIT clause (DELETE ROWS or PRESERVE ROWS). No, we don't drop tables since there is only one type of temporary table. You just specify how it responds to a commit. We found that we had to use the session specific one in order to make things work with CF.
When we chose maintain connection in CF admin, we effectively created one session in ORACLE for all users at once. And a big mess since the GTT was now shared across all the users. Maybe there is some combination of CF settings and code that would allow us to maintain connections and have the GTT be specific to each stored proc call but I haven't found it yet. It is possible I was doing something wrong in the stored proc that is making the transaction type not work properly. I guess I'll have to try and set up some test cases if I can find the time. -- Warren ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318703 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
