Subject Re: [firebird-support] Stored Procedure: variable does not want to be reset to NULL
Author Dmitry Sibiryakov
On 22 Sep 2005 at 17:12, Bambang P wrote:

>In a stored procedure, a variable has been assigned a value.
>Later on, when it is used to receive select result which does not
>return any result, isn't the variable suppossed to be null now?

Nope. No results from query -> no assignments -> old value.

>Is it by designed?

Yes.

--
SY, Dimitry Sibiryakov.