Select Data from Advanced Queues??

[aljubicic]

Hi,

Just need to know how to do a SQL select on say the data, node etc field from the SWLOCALMSG object which is used as a type for an advanced Queue.

CREATE OR REPLACE
TYPE SWLOCALMSG AS OBJECT (
msginfo VARCHAR2(500),
node VARCHAR2(24),
contenttype NUMBER(2),
data VARCHAR2(1000)
);
/


BEGIN
DBMS_AQADM.CREATE_QUEUE_TABLE
(
QUEUE_TABLE => 'BGMBOXTABLE1'
,QUEUE_PAYLOAD_TYPE => 'SWLOCALMSG'
,COMPATIBLE => '8.1.3'
,STORAGE_CLAUSE => '
TABLESPACE IWS_DATA
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 256K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
)'
,SORT_LIST => 'ENQ_TIME'
,MULTIPLE_CONSUMERS => FALSE
,MESSAGE_GROUPING => 0
,COMMENT => 'default background mbox'
);
End;
/

Would it be something below(syntax??). Any examples would be of great help.

select ??(data component of SWLOCALMSG) from bgmboxtable1

Regards
Anthony