Object Types with an invalid body is not being detected when compiling them in TOAD. In the schema browser, on the Types tab. Issuing an "ALTER TYPE <object> COMPILE BODY" from the SQL Editor also does not catch the compilation error when executing curent statement.
WORKAROUND
To get the error, the user must search the user_errors or all_errors views.
STATUS
This issue is fixed in TOAD 8.5. This version can be downloaded at http://questsupportlink.quest.com/prod_upgrade_alert.asp.
Functionality has now changed in the 8.5 release, TOAD does not allow you to execute Procedures, Functions, Packages or Types as "Execute Statement" or "Execute Statement at Cursor". You must now use the "Execute as Script" or compile the object in the Procedure Editor.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center