[Firebird-devel] [Bug #133025] Server hangs when executing Stored Proc more than once

[<no...@so...>]

Bug #133025, was updated on 2001-Feb-18 15:58
Here is a current snapshot of the bug.

Project: Firebird
Category: Core Engine
Status: Open
Resolution: None
Bug Group: Confirmed Bug
Priority: 9
Submitted by: helebor
Assigned to : nobody
Summary: Server hangs when executing Stored Proc more than once

Details: When executing a SP inside a loop that accepts input parameters,
the server hangs on the second iteration if the statement is not unprepared
and re-prepared between iterations.  This is an old bug which goes back to
v. 5.x as well.

Note that, if you add a SUSPEND statement at the end of the SP and return a
dummy parameter, you can multi-call the SP with SELECT instead of EXECUTE
without the need to do the unprepare/prepare when passing subsequent sets
of inputs.

For detailed info, follow this link:
http://sourceforge.net/bugs/?func=detailbug&bug_id=133025&group_id=9028