I see the firebird process accounting for 22-25% of my CPU in the task manager (which makes sense because its a quad). I know the last line of delphi code executed is calling the "execute procedure ProcedureName". And as I mentioned, it actually does complete the procedure if I run this data conversion on a smaller number of records, it only seems to hang on larger databases.

--- In firebird-support@yahoogroups.com, "Leyne, Sean" <Sean@...> wrote:
>
>
>
> > This all works fine when I run the procedure manually using flame-robin (for
> > 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.
>
> If 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.
>
> How do you know that the SP is actually running/hung?
>
>
> Sean
>