Re: Weird issue with a PACKAGE in 11g

one further idea: could it be that there two sources (e.g. create scripts) of package a, one containing procedure d and the other one does not?
Please define recompile. Is it "Alter package a compile;" oder did you do "create or replace package a ...".

Regards

Lothar

On 25.08.2015 23:42, Marcos Colmenares H. wrote:
> Good Day,
>
> Schema would be called xxxxx and he is in fact the owner of the
> packages xxxx.a.d
>
> Best Regards,
>
> Marcos Colmenares H
>
> --
>
> 2015-08-25 17:03 GMT-04:30 TJ Kiernan <tkiernan_at_pti-nps.com
> <mailto:tkiernan_at_pti-nps.com>>:
>
> Is this maybe a name-resolution thing? Do you have a schema
> called a? Then it’d be looking for an object called d in the a
> schema.
>
> HTH,
>
> T. J.
>
> *From:*oracle-l-bounce_at_freelists.org
> <mailto:oracle-l-bounce_at_freelists.org>
> [mailto:oracle-l-bounce_at_freelists.org
> <mailto:oracle-l-bounce_at_freelists.org>] *On Behalf Of *Marcos
> Colmenares H.
> *Sent:* Tuesday, August 25, 2015 4:26 PM
> *To:* Raza Siddiqui
> *Cc:* oracle-l_at_freelists.org <mailto:oracle-l_at_freelists.org>
> *Subject:* Re: Weird issue with a PACKAGE in 11g
>
> Hi Raza,
>
> 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
> <mailto: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
> <mailto: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