TOraAlerter problem with pipes consisting packed messages
Posted: 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
OnEvent method adds lined to memo like this
and application hangs after adding sysdate to memo. Before 6.90.0.54 all was working properly.[/code]
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;
Code: Select all
memo1.Lines.Add(message);
for i := 1 to 2 do
memo1.lines.add(oraalerter1.UnpackMessage);