|Subject||RE: [firebird-support] Stored procedure never completes|
> This all works fine when I run the procedure manually using flame-robin (forIf the SP runs fine from an external tool, then I would suspect that my Delphi program is not calling the SP correctly, or handling the completion of the SP.
> testing). But when I run the procedure as part of the data conversion
> program in (Delphi XE), the stored procedure hangs. Then I stop the
> program , immediately run the same procedure from flame-robin, and it
> successfully executes in 2 minutes.
How do you know that the SP is actually running/hung?