Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> converting for DBMS_AQADM

converting for DBMS_AQADM

From: <burkeblackman_at_my-deja.com>
Date: Wed, 25 Aug 1999 20:31:58 GMT
Message-ID: <7q1jru$cq7$1@nnrp1.deja.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US