Re: How to check whether package body was defined correctly?

What Oracle errors does an attempt to use the package result in? The package will have a dba_object.status = 'INVALID' if anything is wrong with it.

If the package is VALID and you get errors when you execute it then those are runtime errors and incidcate that either you have bad data, bad logic, or bad code such as performing a select into where no data exists and not coding the no_data_found or too_many_rows exception handlers.

When you post to the comp.database.oracle.* forums please always include the Oracle version and platform. When dealing with Oracle Error Codes list them. Bugs and features are versions specific and the error codes provide clues to the problem.

HTH -- Mark D Powell -- Received on Fri Sep 23 2005 - 09:29:16 CDT