Re: Again DBMS_SQL
From: Chris Halioris <halioris_chris_nonlilly_at_lilly.com>
Date: 1997/03/11
Message-ID: <3325A086.CBA_at_lilly.com>#1/1
Date: 1997/03/11
Message-ID: <3325A086.CBA_at_lilly.com>#1/1
Andrea wrote:
>
> Hi,I have again problems with the DBMS_SQL package.
>
> If i try to use that package I have these errors:
>
> ORA-04068: existing state of packages has been discarded
> ORA-04063: package body "SYS.DBMS_SQL" has errors
> ORA-06508: PL/SQL: could not find program unit being called
>
> I have tried to re-create the package, but nothing change.
Are you saying that DBMS_SQL is listed as INVALID in the database. If that is the case, if you recompile dbms_sql what kind of errors do you get?
Chris Halioris
Tactics, Inc.
hali_at_tacticsus.com
Received on Tue Mar 11 1997 - 00:00:00 CET