Oracle Advance Queue from C#

  • Thread starter Thread starter Franco, Gustavo
  • Start date Start date
F

Franco, Gustavo

Sorry to post here, but this doesn't fit on any place..

Somebody knows how to implement Oracle Advance Queue from C#? I can't find a
single example.

Thanks,
Gustavo.
 
I've not seen an example, but I believe its all held in the oracle database,
as opposed to file based messaging like MSMQ. Hence, the trick may be to
simply talk oracle with ODP.NET and learn what stored procedures to call.
You may find that the oracle developer tools has an example.

http://www.oracle.com/technology/tech/windows/odpnet/index.html

Regards

John Timney
ASP.NET MVP
Microsoft Regional Director
 
The problem with that is that I need to receive asynchronous messages.



If I have to do it with ODP then I have to query the DB, which it will spend
DB resources, client Resources, and also if the client don't do it very
often then will be delays between the data inside DB and the client itself.



For that AQ is perfect for that, where you can subscribe to be listening for
a message when them arrives.



So, far what I'm starting to see it can be done using OO4O (Oracle Objects
for Ole) but it is a COM object to be used from VB6, basically for sure I'll
be able to use it on .Net, but I'll have to keep two open connections to DB,
OO4O and ODP also keeping two different styles to access to DB.



It is much better if I can do it everything from ODP, but it doesn't support
it.



Thanks,

Gustavo.
 
Back
Top