Re: Weird issue with a PACKAGE in 11g

Thats my main issue actually, it never shows up as invalid... it keeps showing up as valid. In the production enviroment we went as far as doing a mass recompile of all objects, but it happened again.

Sounds interesting as a last resort, recompiling all objects every time they are accesed here would be caos.

Best Regards,

Marcos Colmenares H

--

2015-08-25 16:53 GMT-04:30 Raza Siddiqui <raza.siddiqui_at_oracle.com>:



> Marcos

>

> Look at any dependent objects being dropped or altered...that event will

> cause a "stored procedure" (package spec, body, function or procedure) to

> become invalid.

>

> If memory serves, there's a parameter that can recompile all DB-stored

> pl/SQL code to be recompiled every time it's invoked....

>

> Corrections / additions welcome.

>

> Raza

>

>

> On Aug 25, 2015, at 14:12, "Marcos Colmenares H." <

> mcolmenares_at_newtechsistemas.com.ve> wrote:

>

> Good Day,

>

> We've been experiencing waht seems to be a bug with a certain package, but

> because of the way it presents itself im not sure if its really a sole

> occurence.

>

> We have a package named A with an internal procedure called D (a.d). It

> works as intended and when we query invalid or not compiled objects

> everything seems OK.

>

> Then one of the logs shows us an error message like so

>

> *ORA-06508: PL/SQL: could not find program unit being called** a.d*

>

>

>

> when we re-check for invalid objects (SELECT *  FROM all_objects WHERE

> owner='xxxxx' AND status='INVALID';), everything seems fine and i see no

> indications of any error whatsoever, but around a month ago trying to fix

> the issue when it first appeared i decided to re-compile the package just

> to try if that fixed it, and it did. The re-compilation works without a

> hitch when the error occurs but its a production enviroment and now its

> happening on the testing enviroments as well without any indication as to

> why and to be honest im runing out of ideas.

>

>

> Any of you had a similar situation happen to you?

>

>

>

> Best Regards,

>

> Marcos Colmenares H

>

> --

>

>


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