Home » Infrastructure » Windows » DBMS_ALERT in c# (3 Merged) (oracle 11)
DBMS_ALERT in c# (3 Merged) [message #532574] Wed, 23 November 2011 09:22 Go to next message
dbuch
Messages: 7
Registered: July 2011
Location: Belgium
Junior Member
Hi

has anyone got an example of how to listen to an oracle DBMS_ALERT from within c#, and to generate an event when it occurs?

Alternately, can I use the queuing for this?
I have a stored procedure which is a length operation and I want to notify the client application that it has finished so it can process the data further. This notification must come from the database and not have the application run a timer.

thanks!!

cheers


Re: DBMS_ALERT in c# [message #532579 is a reply to message #532574] Wed, 23 November 2011 09:25 Go to previous messageGo to next message
BlackSwan
Messages: 21967
Registered: January 2009
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

I am not sure that you can get there from here.

http://www.oracle.com/pls/db112/search?remark=quick_search&word=dbms_alert
Re: DBMS_ALERT in c# [message #532591 is a reply to message #532579] Wed, 23 November 2011 09:39 Go to previous messageGo to next message
dbuch
Messages: 7
Registered: July 2011
Location: Belgium
Junior Member
when I tried to post the message I got a time out and bad gateway, so tried a few times.. hence the duplicate messages.. was not done on purpose Smile

I have checked all over for examples, but can only find examples from within pl/sql, and NOTHING in how to call it from c#.. and how to get an event triggered on it.

thanks
Re: DBMS_ALERT in c# [message #532596 is a reply to message #532591] Wed, 23 November 2011 09:43 Go to previous messageGo to next message
BlackSwan
Messages: 21967
Registered: January 2009
Senior Member
>I have a stored procedure which is a length operation and I want to notify the client application
Control does not get returned to invoking procedure until after long running procedure completes.
Re: DBMS_ALERT in c# [message #532607 is a reply to message #532596] Wed, 23 November 2011 10:22 Go to previous messageGo to next message
dbuch
Messages: 7
Registered: July 2011
Location: Belgium
Junior Member
Hi

yes I know. in my stored proc, I run my query and at the end of the query, I raise the alert. I want my c# application to be notified when I raise this and act on it.

its the c# code that I need an example for.

thanks
Re: DBMS_ALERT in c# [message #532611 is a reply to message #532607] Wed, 23 November 2011 10:48 Go to previous message
Michel Cadot
Messages: 57645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So it may not be the good forum to ask but in C# one?

Regards
Michel
Previous Topic: Does windows7 support oracle 11g to install
Next Topic: Using Oracle Developer 6i and 10g on the computer.
Goto Forum:
  


Current Time: Thu Apr 24 08:54:38 CDT 2014

Total time taken to generate the page: 0.08362 seconds