Re: What makes a stored procedure 'INVALID'?

Hi,

Two things that I know of:

1. It compiled with errors.
2. Something it called went invalid or was deleted.

at the command line, type ALTER PROCEDURE xxxx COMPILE; then SHOW ERR

Good luck,

Steve
Jeffrey Mark Braun wrote in message <7gq077$eqe$1_at_halcyon.com>...
>I was trying to look this up in our Oracle documentation, but couldn't
>find it, so maybe someone out there knows the answer.
>
>We use a lot of stored procedures, and I refer to the the user_objects
>table quite a bit, but I noticed that many of the stored procedures listed
>in this table have a status of 'INVALID', yet the procedure runs justs
>fine and appears to have nothing wrong with it.
>
>I can imagine if a stored procedure dependence changes (such as another
>stored procedure, table, etc) then the stored procedure might be flagged
>invalid until reloaded, but I reloaded all of our procedures and I still a
>bunch of marked as invalid, although they're working fine for me.
>
>Anyway, just curious what conditions make a procedure invalid.
>
>Thanks.
>
>-jeff
Received on Wed May 05 1999 - 13:30:57 CDT