This discussion is archived
1 Reply Latest reply: Oct 23, 2012 1:44 AM by user648708 RSS

Unable to query attribute having systimestamp data type in queue payload

Haider Hussain Newbie
Currently Being Moderated
Hi,

My current queue payload type has a component having timestamp datatype.
Eg : my_queue_payload(attr1 varchar2(100),
attr_timestamp timestamp);


I have successfully managed to query the component attr1 using the below query on the queue table(my_queue_tab)

select a.user_data.attr1 from my_queue_tab a where a.msgid = 'AAABBBCCC1234';

However, I am unable to query the component attr_timestamp using the above query due to Oravle error 'invalid identifier'.

I have the following queries with respect to the above issue :

1. I am unable to query attr1 if i dont provide an alias for the queue table, please let me know the reason why ?
2. I am unable to use any Oracle function on attr1 , please let me know the reason why ?
3. How I can query attr_timestamp ?

Could you please help.

Thanks in advance.

Regards,
Haider

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points