compile a package problem

From: <rkatofia_at_my-deja.com>
Date: 2000/05/04
Message-ID: <8esot9$sak$1@nnrp1.deja.com>#1/1

Is there a way to compile a package body and not force the users to reconnect? The package compiles with no problems but the users get the following error until they reconnect.

ORA-04068: existing state of packages has been discarded ORA-04061: existing state of package body "CPCOMP1.FSBO_ADS" has been invalidated
ORA-04065: not executed, altered or dropped package body "CPCOMP1.FSBO_ADS"
ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at line 1

again the package is not invalid.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu May 04 2000 - 00:00:00 CDT