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.
>
> Thanks in advance.
>
> Andrea Savino
> A.Savino_at_agora.stm.it

And what are the errors in DBMS_SQL? You need to rerun dbmssql.sql. When you have done that, if there are errors, type show err. This should give you (and possibly, us) a clue to your problem.

-- 
Diana Duncan	     | My opinions are my own.
Sr. Consultant	     | 
REALOGIC, Inc.	     | Excitement, Adventure and
dduncan_at_realogic.com | Really Wild Things - Z.B.