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 -> Procedure is invalid

Procedure is invalid

From: Dirk <dirk.linden_at_web.de>
Date: Fri, 18 Oct 2002 21:46:12 +0200
Message-ID: <aopoe8$r4n$02$1@news.t-online.com>


Hi,

I use Oracle on Linux 8.1.7.
When I store a procedure (test), it has the status "invalid" and I cannot switch to valid.
The procedure only inserts some values into a table and gives no argument back, so there is nothing special to it. I think syntax is fine and I can find no errors.

Could there be a missing reference?
I think there could be also something wrong with the rights on the object?

Thanks,

Dirk Received on Fri Oct 18 2002 - 14:46:12 CDT

Original text of this message

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