This content has been marked as final. Show 2 replies
maybe your procedure has been invalidated by some DDL, e.g. a new column has been added to a table that is referenced in your procedure. The status will be INVALID until you recompile it or until you call the procedure, then it will be recompiled automatically.
(may be my proc has no errors).Very likely.