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 -> how to get a msgid from enqueue in Visual Basic (using oo4o)

how to get a msgid from enqueue in Visual Basic (using oo4o)

From: bain hollister <bain.hollister_at_uk.ey.com>
Date: 23 Oct 2001 03:05:16 -0700
Message-ID: <f5dcae65.0110230205.60ee7a61@posting.google.com>


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

Original text of this message

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