Temp tables visible between sessions

Hey guys. We're executing an SPL routine from PHP using a persistent connection. We are getting this error unless I run UPDATE STATISTICS FOR FUNCTION before I run the SPL routine. This is the error we're getting: Warning: ifx_htmltbl_result() [function.ifx-htmltbl-result]: Can not fetch next row on cursor E [SQLSTATE=IX 000 SQLCODE=-958] (cursor1498_2f656470) in C:\\\\Program Files\\\\Apache Software Foundation\\\\Apache2.2\\\\htdocs\\\\apps\\\\datacannon\\\\services\\\\buffer.php on Any tips would be appreciated. Thanks, Paul

Your SPL function creates a temp table. The life of the temp table is the life of the session not the life of the function. The only way to handle it is to put in an ON EXCEPTION clause to catch the -958 error and drop and recreate the temp table there. You cannot successfully drop the temp table at the end of the function, even if you don't need it after the function runs, because if some client doesn't drain the FOREACH cursor returning rows from whatever query is in there, and so never executes the end of the function the temp table will still exist. The only workable option is to trap the 'Temp table already exists' error and deal with it then continue. Art S. Kagel ----- Original Message ----- From: Paul Iancu <ids@iiug.org> At: 8/11 6:20:30 Hey guys. We're executing an SPL routine from PHP using a persistent connection. We are getting this error unless I run UPDATE STATISTICS FOR FUNCTION before I run the SPL routine. This is the error we're getting: Warning: ifx_htmltbl_result() [function.ifx-htmltbl-result]: Can not fetch next row on cursor E [SQLSTATE=IX 000 SQLCODE=-958] (cursor1498_2f656470) in C:\\\\Program Files\\\\Apache Software Foundation\\\\Apache2.2\\\\htdocs\\\\apps\\\\datacannon\\\\services\\\\buffer.php on Any tips would be appreciated. Thanks, Paul ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.