Re: Stored procedures problem

Hi,
it seems to me as if the execute rights are not properly set. the same error occrurs when you select from a table for wich you have not the permission to select.
Login to SQL*plus with the user that created the package and execute it, when it works you should look up the user priviliges and execute the procedure "full qualified" (schema.package.procedure)

I hope I could help you.

Thomas
"Traroth" <traroth_at_newyorkcity.com> schrieb im Newsbeitrag news:9prrsg$2bv$07$1_at_news.t-online.com...
> Hi,
>
> I've got a problem with Oracle 8.1.7 on NT4. When I try to execute a
stored
> procedure (through JDBC), I get these messages (It's in german) :
>
> ORA-04068: Der bestehende Status der Pakete wurde aufgehoben
> ORA-04063: package body "FISCHER.OOTELPROCS" hat Fehler
> ORA-06508: PL/SQL: aufgerufene Programm-Einheit ist nicht zu finden
> ORA-06512: in Zeile 1
>
> The system don't find the procedure, but why ? It exists !
>
> Can you help ?
>
> Thanx
>
> Traroth
>
>
Received on Mon Oct 08 2001 - 04:48:42 CDT