ORA-02303: cannot drop or replace a type with type or table dependents

Question

I'm newbee in oracle and I try to change varchar(50) to 250

CREATE OR REPLACE TYPE CEQ_OWNER.TYPE_REC_PARAE2
AS OBJECT    
(
    ...
    BONETAT_DESC  VARCHAR2(250),
    ... 
)
/

I get ORA-02303: cannot drop or replace a type with type or table dependents

user_4019239 · Answer

There are some dependency for the Object you are trying to Modify or Drop.

If you want to skip this first drop the dependant Object and try to DROP or MODIFY

Like in the below Screenshot

Regards, Arul