We had a problem in production the other day where the package headers lost their detail. It wasn't every package, but it was at least 20% of all packages owned by the DORIS schema only had their rem comments at the top when viewed through Toad and did not have their detail lines. We had to recreate the packages via sql plus.

Another dba had on Sunday run the utlrp.sql script to recompile everything, but didn't notice any problems from the result. Anybody ever seen this before? We're running 8.1.7.4.0 on AIX. Thanks.