Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> What makes a stored procedure 'INVALID'?

What makes a stored procedure 'INVALID'?

From: Jeffrey Mark Braun <jeffb_at_halcyon.com>
Date: 5 May 1999 10:47:19 -0700
Message-ID: <7gq077$eqe$1@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 - 12:47:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US