This discussion is archived
4 Replies Latest reply: May 14, 2013 12:14 PM by user8604530 RSS

Oracle 11gR2: modify an existing queue ... is this possible?

user8604530 Newbie
Currently Being Moderated
Hi folks,

I need to modify an existing queue:

system@orcl> alter TYPE AQADM.QUEUE_MESSAGE_TYPE
2 modify attribute(discount_expiration_date timestamp(3) with time zone) cascade;
alter TYPE AQADM.QUEUE_MESSAGE_TYPE
*
ERROR at line 1:
ORA-22324: altered type has compilation errors
ORA-22328: object "AQADM"."QUEUE_MESSAGE_TYPE" has errors.
PLS-00719: only widening of attribute 'DISCOUNT_EXPIRATION_DATE' constraints is allowed
ORA-06550: line 0, column 0:
PL/SQL: Compilation unit analysis terminated

It was discount_expiration_date timestamp(3) with LOCAL time zone ... earlier and now they want to make it only WITH TIME ZONE

Please advice/suggest ... how to go about, is it doable or ...?

Thanks in advance.

Legend

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