> 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