Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> converting for DBMS_AQADM
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.
Received on Wed Aug 25 1999 - 15:31:58 CDT