Progress of stored procedure

[safir]

Hi,
please, is there any convenient way to obtain information about progress of stored procedure (typically loop-end loop) for display progress bar?

Thank you.

 

[Marco Kalter]

To communicate progress information back to the client you can use the dbms_pipe package. Just send a message to a uniquely identified pipe (use dbms_session.unique_session_name as its name) and use the TOracleEvent component in your client application to display this progress information.

------------------
Marco Kalter
Allround Automations

 

[Gene]

Hi, Marco
I use a code in duplicated session (oraDBMSSession) and use this Name for OracleEvent.
But when I use this code, I can't receive a pipe-messages immediately. Only when stored procedure is finished.

Please help solve this problem

My Code:
procedure TData.OracleEventEvent(Sender: TOracleEvent; const ObjectName: string; const [Ref] Info: Variant);
var i:integer;
begin
Main.Memo.Lines.Add('Событие из ' + Sender.Name + ' на ' + ObjectName);
if VarIsArray(Info) then
for i := 0 to VarArrayHighBound(Info, 1) do
Main.Memo.Lines.Add(Info);
end;

 

[Marco Kalter]

That's difficult to analyze from here. Perhaps you can check out the eventdemo project and compare it to your own project?