Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Again DBMS_SQL
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