compile TYPE
685605Feb 17 2009 — edited Feb 17 2009I need to compile an object TYPE, but anyway i have error.
1) Using the comand alter type body, i have error after to compile, but on show errors i don't have errors:
SQL> alter type body TYPE_NAME compile ;
alter type body TYPE_NAME
compile
*
ERROR at line 1:
ORA-00922: missing or invalid option
SQL> show errors type body TYPE_NAME
;
No errors.
2) Using the comand alter type, i have an error different after to compile and continue without errors on object:
SQL> alter type TYPE_NAME compile ;
alter type TYPE_NAME
compile
*
ERROR at line 1:
ORA-02311: cannot alter with COMPILE option a valid type with type or table dependents
SQL> show errors type TYPE_NAME
;
No errors.
h4. Can someone help me, please?????