We've been recently getting errors when our developers compile procedures. Selecting a procedure and right clicking over to select COMPILE causes an ORA-01401 Hosdef does not exist error, followed by a trace file in the db which includes the following
** SESSION ID 137.907) 2003-04-07...