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
Error ORU-10015 using alerts
Re: Error ORU-10015 using alerts
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
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
Re: Error ORU-10015 using alerts
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.
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.
Re: Error ORU-10015 using alerts
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.
P.S. Please try to reproduce in the OCI mode.