Hi, My coldfusion server (v 6.1) seems to handle oracle (v 9.0.2) global temporary tables like ordinary tables. When many users are inserting data, when selecting, each one of them get all the records inserted by everyone. I used both ON COMMIT PRESERVE ROWS (is what I actually need) and ON COMMIT DELETE ROWS options when creating the temp. table, but got the same result. I also did a test inserting data using a stored procedure with PRAGMA AUTONOMUS_TRANSACTION with no success.
I also mention taht the same tests performed on coldfusion, worked fine using SQL Plus. Tests OS: win and solaris. Any help or advice using oracle temporary tables with coldfusion will be apreciated. Thank you, -- Razvan D. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2578 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
