Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Procedure is invalid
Dirk,
The first question is how are you trying to change the status from invalid
to valid.
The way you should do this is
SQL> alter procedure procedure_name compile;
will will either see a success message or a failure message.
If you get the failure message do a
SQL>show err
and look at the errors.
If this is a permissions problem ask your freindly DBA
from the proper permissions.
"Dirk" <dirk.linden_at_web.de> wrote in message news:<aopoe8$r4n$02$1_at_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 Mon Oct 21 2002 - 15:55:32 CDT