>>As workaround you can try to issue Release < variable > before Local < variable >.
>>
>>
>>>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
>
>That's probably what we will end up doing. Have you ever seen this problem before?

We're using MS SQl Server here.