6 Replies Latest reply: Aug 17, 2012 12:12 PM by rp0428 RSS

    Oracle Type ... need to alter datatype from NUMBER to VARCHAR2

      Hi folks,

      Is this possible, need to change/alter an existing TYPE object of QUEUE_MESSAGE_TYPE, from NUMBER to VARCHAR2, when tried
      ALTER TYPE ...
      MODIFY ...

      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 'UNID' constraints is allowed
      ORA-06550: line 0, column 0:
      PL/SQL: Compilation unit analysis terminated

      Elapsed: 00:00:00.36

      Need assistance, thanks in advance.