Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> how to get a msgid from enqueue in Visual Basic (using oo4o)
Hello,
We are implementing a system that requires large documents to be passed over Advanced Queue. Our understanding is that to enqueue a CLOB, we need to access the CLOB locator in the queue table. To find the correct row n the queue table, we use the messageid returned from enqueue.
The RAW message handle returned from enqueue in Visual Basic is in the
form of a byte array.
The problem is how do we convert this to a usable hex representation
to find the correct row in the queue table.
Any suggestions, ideas gratefully received.
Regards
Bain Hollister
ps. code snippets
--Object type for carrying XML update
CREATE OR REPLACE TYPE xmlq_typ AS OBJECT (
messageid VARCHAR(40), messageType VARCHAR(40), destinationAddress VARCHAR(100), username VARCHAR(40), password VARCHAR(40), clientDoc VARCHAR(2000), userDetail VARCHAR(2000), userData CLOB);Received on Tue Oct 23 2001 - 05:05:16 CDT
![]() |
![]() |