Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Again DBMS_SQL

Re: Again DBMS_SQL

From: Chris Halioris <halioris_chris_nonlilly_at_lilly.com>
Date: 1997/03/11
Message-ID: <3325A086.CBA@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 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US