Oracle 9.2.0.4/HP
alter type, version, PL/SQL, evolution, user_objects
When a type is altered, Oracle creates a new version of it The Browser shows both versions. If I then view/edit the source code it will show source code being doubled.
1. The browser should show version in parentheses next to it.
2. PL/SQL Developer should add to the predicate the version number
Btw, I just started using this tool and I am amazed as to how much it can do!!! - Great job
Example;
alter type catalog_item_t add attribute(published_dt date) ;
If I then view the source code...
create or replace type catalog_item_t as object (
type catalog_item_t as object (
id integer,
id integer,
title varchar2(4000),
title varchar2(4000),
not instantiable member function ck_digit_ok
not instantiable member function ck_digit_ok
return boolean,
return boolean,
member function print
member function print
return varchar2
return varchar2
) not instantiable not final
) not instantiable not final
alter type catalog_item_t add attribute(published_dt date) ;
alter type, version, PL/SQL, evolution, user_objects
When a type is altered, Oracle creates a new version of it The Browser shows both versions. If I then view/edit the source code it will show source code being doubled.
1. The browser should show version in parentheses next to it.
2. PL/SQL Developer should add to the predicate the version number
Btw, I just started using this tool and I am amazed as to how much it can do!!! - Great job
Example;
alter type catalog_item_t add attribute(published_dt date) ;
If I then view the source code...
create or replace type catalog_item_t as object (
type catalog_item_t as object (
id integer,
id integer,
title varchar2(4000),
title varchar2(4000),
not instantiable member function ck_digit_ok
not instantiable member function ck_digit_ok
return boolean,
return boolean,
member function print
member function print
return varchar2
return varchar2
) not instantiable not final
) not instantiable not final
alter type catalog_item_t add attribute(published_dt date) ;