Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

compile TYPE

685605Feb 17 2009 — edited Feb 17 2009
I 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?????
This post has been answered by 21205 on Feb 17 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 17 2009
Added on Feb 17 2009
5 comments
3,024 views