If you modify a type definition, the browser shows an entry for every modificaton. What is even worse, if you then try to view/edit the type, the source for ALL of the versions are interleaved and displayed in the edit window.
Example:
SQL> create type t_test as object (att1 number);
Type created
SQL> alter type t_test add attribute att2 number;
Type altered
SQL> alter type t_test add attribute att3 number;
Type altered
Now, If I browse to types, I see three types named t_test. If I open any of them in the edit/view window, I see:
create or replace type t_test as object (att1 number)
type t_test as object (att1 number)
type t_test as object (att1 number)
alter type t_test add attribute att2 number
alter type t_test add attribute att2 number
alter type t_test add attribute att3 number
Is there a fix/workaround for this???
Thanks
Example:
SQL> create type t_test as object (att1 number);
Type created
SQL> alter type t_test add attribute att2 number;
Type altered
SQL> alter type t_test add attribute att3 number;
Type altered
Now, If I browse to types, I see three types named t_test. If I open any of them in the edit/view window, I see:
create or replace type t_test as object (att1 number)
type t_test as object (att1 number)
type t_test as object (att1 number)
alter type t_test add attribute att2 number
alter type t_test add attribute att2 number
alter type t_test add attribute att3 number
Is there a fix/workaround for this???
Thanks