API documentation

3004

Hi,
Where do I get Java API documentation for oracle.AQ.* packages. I would like to know how to find out payload type whether it's Object or RAW payload. Can someone help me ?
Thanks !!

3004

The oracle.AQ.* package is documented in the Oracle8i supplied java packages reference
http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/a85456/title.htm

The payload type returned in AQMessage will depend on the payload_type specified when creating the queue table. For queue tables created with 'RAW' as the payload_type, you'll need to use AQRawPayload. For queue tables created with any other Oracle object type, you'll need to use AQObjectPayload class.

3004

Hi,
what I meant was, for the given Queue and queue table, I would like to know the payload type. Then based on that, I need to change my enqueue/Dequeue logic. For OBject payload I use an oracle object with CLOB data type. So is there any way we can find out the payload type without querying the USER_QUEUE_TABLES?
Thanks !!

3004

You can do the following

AQQueueTable qt = aq_sess.getQueueTable("scott", "my_qtable");

AQQueueTableProperty qt_prop = qt.getProperty();

String payload_type = qt_prop.getPayloadType()

null

3004

Thanks !!. It works fine