Why does a Delphi program hang when executing a MS SQL 2008 R2 stored procedure?

Question

Delphi

We have a DB: MSSQL Server 2008 R2
Muzzle for it on Delphi 7. The
stored procedure in MSSQL includes work with the temporary table.
Problem:
A Delphi program hangs when executing a MS SQL 2008 R2 stored procedure.
At the same time, in MSSQL itself, when exec is called with attributes, everything is executed.
The problem seems to be solved by replacing the local time. table to the global one (in a stored procedure).
But the question remains why the program hung at local time and stopped hanging at global time. table?

Answer 1

The program didn't crash. The execution of HP hung up, it was simply performed for a long time.
During normal execution, through the DataSet, the interface is frozen until the execution of the SQL query is completed.