Re: Weird Oracle Error with a Java Call

Hi,

As far as I know in library cache cursors depend on the package header only not the package body.
So recreating just the package body does not invalidate the cursor. Package body itself depends on the package header.

So if you just replace package body the cursors in the library cache depending on the package (header only) remains valid. So I think if you replace package header also then the cursor would be invalidated and you won't see this error

amit

At 08:24 AM 2/24/2006 -0500, Mladen Gogala wrote:

>On 02/24/2006 08:06:51 AM, Mercadante, Thomas F (LABOR) wrote:
>
> > If we just replace the package body, the function does not get marked as
> > needing recompile. But the Java application still throws an Oracle
> > error - Ora-6508 - program unit not found. Once the application is
> > restarted, all is fine.
>
>Tom, you probably have something in the library cache that is marked
>invalid, and
>because it's just a body, Oracle doesn't see the need to reload it. You can
>try seeing what's in the library cache, by looking into V$LIBRARYCACHE or,
>if everything else fails, dump library cache through oradebug by doing:
>
>ORADEBUG DUMP LIBRARY_CACHE 12
>
>--
>Mladen Gogala
>http://www.mgogala.com
>
>--
>http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l