> Are you saying that it makes no difference whether you use local or > temporary tables?
Well it seems (on my first tests) that as long as your queries are in a transaction all the queries can access the temp table. Global tables can be access by other transactions, there may be clean up differences too. (local tables are dropped automatically when the fall out of scope ) , however I'm not sure how this works in a pooled connection environment. > If so, did you get to the bottom of the original problem? > Spike Not really a problem, I was on new ground, so I was seeing if anyone has come across any issues I needed to be aware of. Maybe I'm that first!!! Actually Better check this stuff out with the JDBC datascources Justin -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
