Re: Procedure is invalid

From: Peter van Rijn <pgm.van.rijnRM_at_THIShccnet.nl>
Date: Sun, 20 Oct 2002 23:54:03 +0200
Message-ID: <aov8gi$r6v$1@news.hccnet.nl>

Connect as procedure owner,
"alter procedure xxx compile";
show error

This should give you the reason why it's invalid.

hth,
Peter

"Dirk" <dirk.linden_at_web.de> schreef in bericht 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 Sun Oct 20 2002 - 16:54:03 CDT