Re: invalid packages

Take note Powerbuilder users...

Powerbuilder 4 and 5 check for invalid status on packages and WILL NOT run them like they're supposed to (probably due to being a problem on other dbms' besides Oracle). In case you don't already know, Oracle will automatically recompile invalid packages when/before they're run (after erroring if going across db_link).

Anyways, this results in important rule that Powerbuilder apps must always have packages/procedures recompiled manually after being invalidated.

Tomm Carr wrote:
>
> Stefan Keller wrote:
> >
> > if I make changes in the structure of a table, and PL/SQL-Function
> > reads this table, the function gets the status ‘invalid’.
> > Does a package contain this function, the whole package is ‘invalid’.
> > In this case other functions in the same package are invalid.
> > What can I do or do I have to recompile the packages always when I
> > make changes on one of those tables?
>
> It is not difficult to create a script that searches the data dictionary
> for all stored procedures and packages that are marked INVALID and then
> performs an ALTER...RECOMPILE on them. You can then run this any time
> you do any DDL.
>
> Now that I mention it, with all the packages we have around here, I'm
> surprised we don't have one already. Well, not really -- our DB is
> pretty old and static. However, it still sounds like a good utility to
> have around.
>
> I'll play around with it and see what I can come up with. Or if someone
> already has one (or knows why my tentative idea wouldn't work or has a
> better idea), please let me know.
>
> --
> Tomm Carr
> --
> "Can you describe your assailant?"
> "No problem, Officer. That's exactly what I was doing when he hit me!"
 

-- 
Gary Melhaff
Senior Database Analyst
Weyerhauser Corporation