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.

HTH. Pete

burkeblackman_at_my-deja.com wrote:

> Hello, I am testing out the package DBMS_AQADM on our system. We did
> not purchase the objects option from oracle and therefore have to send
> the payload parameter to the ENQUEUE procedure in this format:
> hextoraw('00dd00ff'). I am trying to find a way to convert the raw
> format over to varchar2 so that I can send text messages to the queue.
> Preferably I would like to avoid the use of raw datatype for that
> parameter anyway. Can you help?
> Thanks,
> Burke
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

--
Regards

Pete

Received on Wed Aug 25 1999 - 16:20:11 CDT