Re: Stored procedures problem

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 8 Oct 2001 19:14:20 +0200
Message-ID: <ts3norpsl5np45@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 Mon Oct 08 2001 - 12:14:20 CDT