Global Temp tables

2007-02-23 Thread Lance J. Andersen
Does anyone have an idea as to why the gobal table cannot be found. Here is the trace output. Regards lance [TopLink Fine]: ClientSession(12549034)--Connection(16309502)--Thread(Thread[AWT-EventQueue-0,6,main])--DECLARE GLOBAL TEMPORARY TABLE session.TL_CMP3_EMPLOYEE (EMP_ID INTEGER NOT

Re: Global Temp tables

2007-02-23 Thread Lance J. Andersen
Mamta, Thanks for taking the time to respond. I had the developer run this using the embedded driver and attached the log. It looks like the prepare is failing on the DECLARE. I have attached the log for your reference. Regards Lance Mamta Satoor wrote: Lance, I am sure you have already