TOraAlerter problem with pipes consisting packed messages

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
AdamKG
Posts: 18
Joined: Fri 13 Nov 2009 10:32

TOraAlerter problem with pipes consisting packed messages

Post by AdamKG » Mon 04 Jan 2010 13:20

Hello,
I recently updated to 6.90.0.54 for RAD Studio 2007 and my application started to hang. I use TOraAlerter set to etPipe to listen for events from DB.

I'm sending from anonymous code

Code: Select all

declare
aResult number;
begin
    dbms_pipe.pack_message(sysdate);
    dbms_pipe.pack_message('First line');
    dbms_pipe.pack_message('second line.');
    aResult := dbms_pipe.send_message('123123', 5, 20000);
end;    
OnEvent method adds lined to memo like this

Code: Select all

  memo1.Lines.Add(message);
  for i  := 1 to 2 do
    memo1.lines.add(oraalerter1.UnpackMessage);
and application hangs after adding sysdate to memo. Before 6.90.0.54 all was working properly.[/code]

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Wed 13 Jan 2010 13:21

We have fixed this problem. The fix will be included in the next build of ODAC.

Post Reply