Hello,
I am using OJMS. I have created queue with payload type "AQ$_JMS_MESSAGE".

While sending messages I create a property that contains user defined message id.

Now, I would like to fire a sql select statement to get messages in order of this property.

Is it possible?

Also, in java, for the same payload type, how can I select user data from the queue table and display the values.

Or in PLSQL how to display the user defined properties of OJMS.

Thanks & regards,
Sanjeev.