Re: converting for DBMS_AQADM

Jonathan

My comments were based on what I was told by the course developer of some AQ training we did internally, but when I got your message I tracked back to an old copy of the documentation to try and confirm. In the 8.0 Application Developer's Guide, in Chapter 11 (Advanced Queuing) is the following warning:

WARNING: If you purchase the product, Oracle8, you will not be able to use Oracle AQ.
If you purchase the product, Oracle8 Enterprise Edition, without the Objects Option, you will be able to use Oracle AQ with queues of RAW type only.
If you purchase the product, Oracle8 Enterprise Edition, with the Objects Option, you will be able to use the full functionality of Oracle AQ.

So you're correct. I asked the course developer again, and their comment was largely along the lines of what you implied - most people are going to want object payloads, so they need the Object Option.

I couldn't find an equivalent statement in the 8i doco.

Hope this clarifies matters.

Pete

Jonathan Lewis wrote:

> Pete,
>
> I think you may be wrong here.
>
> I think I remember reading that AQ with raw payloads
> was supported without Objects, but for more humane
> payloads you needed the object option.
>
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> -----Original Message-----
> From: Pete Sharman <psharman_at_us.oracle.com>
> Newsgroups: comp.databases.oracle.server
> Date: 25 August 1999 22:20
> Subject: Re: converting for DBMS_AQADM
>
> |Burke
> |
> |I don't think you can get this to work. AQ in 8.0 required the
> Objects
> |Option, no if's. no but's. In 8i, if memory serves me correctly,
> object
> |support is built in for Enterprise Edition.

Received on Mon Sep 13 1999 - 15:12:18 CDT