Object type declaration with "%TYPE"
Hello everybody !
I have a question relative to types creation.
I do not see any restriction on Oracle documentation, but i cannot declare objects with reference to the types of columns from my schema.
Any idea of how such declaration is possible ?
Thank you very much,
Catherine
TestCase :
SQL> create table test (a number);
Table créée.
SQL> drop type obj_test;
Type abandonné.
SQL> create type obj_test as object(a number);
/
Type créé.
SQL> create or replace type obj_test as object(a obj_test.a%type);
/
Avertissement : Type créé avec erreurs de compilation.
SQL> sho err
Erreurs pour TYPE OBJ_TEST :
I have a question relative to types creation.
I do not see any restriction on Oracle documentation, but i cannot declare objects with reference to the types of columns from my schema.
Any idea of how such declaration is possible ?
Thank you very much,
Catherine
TestCase :
SQL> create table test (a number);
Table créée.
SQL> drop type obj_test;
Type abandonné.
SQL> create type obj_test as object(a number);
/
Type créé.
SQL> create or replace type obj_test as object(a obj_test.a%type);
/
Avertissement : Type créé avec erreurs de compilation.
SQL> sho err
Erreurs pour TYPE OBJ_TEST :
0