TOracleCustomPackage and TTimer

[MarcDav]

Hi,

Why, when executing a package, no messages is received by the application?

I try to start a TTimer just before calling a stored procedure (Pck.SP(....)).

The program seem frozen, no refresh for the form until the return of the stored proc.!!!!

Any idea why?

By the way. I tried with a thread ... same result!

Thank!

 

[Marco Kalter]

Calling a stored program unit, or performing any other kind of database activity, will indeed block the current thread. If you do this in the main thread of your application, it will "freeze". If you do it in a background thread, your application can continue. However, if the application performs other database activities, it must use its own separate session. Otherwise the main thread will again be blocked by the background thread.