Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to check whether package body was defined correctly?
<qazmlp1209_at_rediffmail.com> wrote in message
news:1127485049.735071.21130_at_g43g2000cwa.googlegroups.com...
> There is a package containing lot of procedures exists in the system.
> Whenever we use the procedures of this package, it gives some errors.
> Now, I would like to check whether there were compilation errors
> reported when this package body was created/defined earlier. Is it
> possible to do this check now i.e. after they were created earlier.
>
example using package named TABLE_API:
select object_type, status from user_objects where object_name = 'TABLE_API' -- will show INVALID if it did not compile correctly
alter package table_api compile body
-- to recompile the body, drop the work body if the package spec should be
recompiled too
select * from user_errors where name = 'TABLE_API' -- lists any compilation errors
++ mcs Received on Fri Sep 23 2005 - 09:33:26 CDT