Help: DBMS_PIPE - communication between two sessions

Hi everobody,
I'm developing application using Developer 2000 (rel 1.3, Forms 4.5) and Oracle database 7.3

I've developed some stored PL/SQL procedure which executes some pretty large transaction, and it takes few hours to complete. Now, I have a request from my client to notify the user about transaction progress, i.e. the phase that transaction is currently in.

I think the best way to do this is to open a new form in the form that calls stored procedure, using OPEN_FORM (to make a new session) and use DBMS_PIPE to communicate between sessions. But it doesn't seem to work the way I expect it. Does someone know how procedures from DBMS_PIPE should be used? Or is there some other way to solve my problem?

Thanks. Received on Wed Nov 01 2000 - 09:51:46 CET