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