Error ORU-10015 using alerts

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
ths
Posts: 53
Joined: Thu 29 Dec 2011 16:18

Error ORU-10015 using alerts

Post by ths » Wed 05 Aug 2015 07:46

Hello,
we have quite offen the following error message using alert component:

ORA-20000: ORU-10015: error:3 waiting for pipe message.
begin DBMS_ALERT.WaitAny(:Name, :Message, :Status, :TimeOut); end;

Could you tell us what can be done to avoid it? I didn't find any related topics on the forum.
Thanks,
Vladimir

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Error ORU-10015 using alerts

Post by AlexP » Thu 06 Aug 2015 05:28

Hello,

We cannot reproduce the problem. Please specify the exact versions of your Oracle client, server, IDE, and ODAC, and also send a small sample demonstrating the problem to alexp*devart*com

ths
Posts: 53
Joined: Thu 29 Dec 2011 16:18

Re: Error ORU-10015 using alerts

Post by ths » Thu 06 Aug 2015 14:24

Hello Alex,
it would be difficult to prepare test application.
We send alert messages from Oracle PL SQL using DBMS_ALERT.SIGNAL function. The message is triggered via Oracle Job when some data conditions are sutisfied. The application is subscribed to the corresponding event. When this event is received, we show popup window to the user.
The error is written to the log table by the database trigger on AFTER SERVERERROR ON DATABASE.
We use ODAC 9.5.14 in net=true configuration, Oracle Server 11g and Delphi5 as IDE.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Error ORU-10015 using alerts

Post by AlexP » Fri 07 Aug 2015 07:39

Try to create a small application demonstrating the problem and send it to us. Unfortunately, without reproducing the problem, we can't help you solve it.

P.S. Please try to reproduce in the OCI mode.

Post Reply