Re: Stored procedures problem

Thank you for your answer, but there are no selected lines for this criteria.

Traroth

Sybrand Bakker <postbus_at_sybrandb.demon.nl> schrieb in im Newsbeitrag: ts3norpsl5np45_at_news.demon.nl...
>
> "Traroth" <traroth_at_newyorkcity.com> wrote in message
> 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
> >
> >
>
>
> > ORA-04063: package body "FISCHER.OOTELPROCS" hat Fehler
>
> The package body didn't compile
> select * from dba_errors where owner = 'FISCHER' and name = 'OOTELPROCS'
> will tell you what the errors are.
> Please ignore the answer of Thomas Ruschival, it doesn't answer your
problem
> at all.
>
> Hth,
>
> Sybrand Bakker
> Senior Oracle DBA
>
>
>
Received on Fri Oct 12 2001 - 03:22:53 CDT