4 Replies Latest reply: May 14, 2013 2:14 PM by user8604530 RSS

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

      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;
      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.