Subject | Stored Procedure double-fire |
---|---|
Author | xvjau |
Post date | 2004-01-23T11:53Z |
Hello all,
I'm getting a strange behaviour from a stored procedure in
FB1.5RC8-linux. When I execute the procedure, it reports "arithmetic
exception...." which is OK, since there is a bug in the procedure.
But while I was debugging it I found that the procedure was fired
TWICE when the error occurs. It is a simple procedure, no
recursive-ness, or any other coded reason for it to call-itself. When
other parameters are passed that don't cause the error, it runs once
only. I executed the "execute procedure" from IBConsole, and used a
UDF to report debugging messages to verfy that it was executing twice.
Is this normal?
Gianni
I'm getting a strange behaviour from a stored procedure in
FB1.5RC8-linux. When I execute the procedure, it reports "arithmetic
exception...." which is OK, since there is a bug in the procedure.
But while I was debugging it I found that the procedure was fired
TWICE when the error occurs. It is a simple procedure, no
recursive-ness, or any other coded reason for it to call-itself. When
other parameters are passed that don't cause the error, it runs once
only. I executed the "execute procedure" from IBConsole, and used a
UDF to report debugging messages to verfy that it was executing twice.
Is this normal?
Gianni