I am using oracle sql developer
Under Types i have something defined like this
create or replace TYPE custom_person_map AS OBJECT
( id NUMBER
, name VARCHAR2(19)
, active CHAR(1)
, crtd_by VARCHAR2(60)
, lst_updt_by VARCHAR2(60)
now if i am trying to replace this line
i get an error
Error: ORA-02303: cannot drop or replace a type with type or table dependents
Anyidea what this is and what the solution could be?
Any help would be greatly appreciated.