We have a cold fusion front end to one of our apps. It will work fine for months on end. Then suddenly it will begin to fail. We have tracked this failure down to one line of code in a Stored Procedure.

Local < variable >

It almost seems as if the variable has been cached as public. If you declare a variable public and then try to re-declare it as local it will error out.

After rebooting the machine, everything is back to normal.

Has anyone seen this problem before?

TIA