problem in result may be because GTT with threading in java

[manvendrapsingh]

Hi all ,

I am creating multiple Threads in my java program which all are then using a stored procedure having a Global Temporary table.
Is it possible to have all threads using different GTT without hardcoding .
will creating a new connection in thread solve the problem

[sakumar9]

All GTTs are session oriented. You will have seperate GTT created for every session. You can use different sessions if you are having problems. If you can provide the details of what is the actual problem, we can think of some alternate solution.

regards
-- Sanjay