Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: UTL_FILE revoke from PUBLIC
Charles, when you see an invalid package body if you just recompile the
body and not the specification then you can generally resolve the
circular dependency chain: alter package owner.packagename compile
body.
Oracle has a white paper or two on the side-effects of removing PUBLIC. You may want to hunt them up for future reference.
HTH -- Mark D Powell -- Received on Sat Apr 23 2005 - 08:14:42 CDT