Oracle Advance Queue from C#

[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.

[John Timney \( MVP \)]

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/tec...net/index.html

Regards

John Timney
ASP.NET MVP
Microsoft Regional Director

"Franco, Gustavo" <gustavo_franco[REMOVEIT]@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP15.phx.gbl...

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.

[Franco, Gustavo]

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.
"John Timney ( MVP )" <ti*****@despammed.com> wrote in message
news:%2******************@TK2MSFTNGP09.phx.gbl...

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/tec...net/index.html

Regards

John Timney
ASP.NET MVP
Microsoft Regional Director

"Franco, Gustavo" <gustavo_franco[REMOVEIT]@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP15.phx.gbl...

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.