Advanced Queue payload not displaying all fields

[Bradnam]

I have an Oracle Queue with a fairly basic object payload - 6 fields; the first 5 are a mixture of numbers and varchars but the last is of type SYS.XMLTYPE.

If I run a simple select against the queue, PLSQL Developer helpfully expands out the payload and shows me the individual fields that make up that payload (and prefixes the field names with 'USER_DATA.'. However, it does not show me the SYS.XMLTYPE field.....it seems I have to specify that field seperately e.g. select a.user_data.my_xml from owner.aq$queue_name_qt a

Any ideas?

Steve

 

[Marco Kalter]

Can you send me the payload object type creation DDL?

 

[Bradnam]

CREATE OR REPLACE TYPE "PNS"."PNS_Q_PAYLOAD_OBJ" AS OBJECT (
ice_customer_id NUMBER(10,0),
account_reference VARCHAR2(20),
key_type NUMBER(2,0),
base_id NUMBER(10,0),
ref_date DATE,
pns_xml SYS.XMLTYPE,
constructor
FUNCTION pns_q_payload_obj RETURN SELF AS RESULT
) final;
/

 

[Marco Kalter]

Thanks, we'll try to reproduce the issue and I will post our findings here.

 

[Marco Kalter]

There was indeed an issue with XMLTYPE attributes within object fields of a result set. Can you download this version and let me know if this resolves it?

 

[Bradnam]

Marco,

I can confirm that the xmltype attribute of the queue payload object that I was viewing does display correctly with the version of PLSQL Developer you asked me to download.

The queue payload field (user_data) is expanded out in the grid view into it's individual attributes and the xmltype field displays a indicator as expected.

many thanks,

Steve

 

[Marco Kalter]

Okay, thanks for letting me know.