Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> What makes a stored procedure 'INVALID'?
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 - 12:47:19 CDT