Problems with Oracle 8.0.5 Migration

From: Prasanti Yalamanchili <pyalaman_at_osf1.gmu.edu>
Date: 4 Mar 1999 07:43:53 GMT
Message-ID: <7bldjp$60j@portal.gmu.edu>

Hi All,

I have migrated my 8.0.4 Database to 8.0.5 and I ran into problems with the DBMS_OUTPUT package. I have couple of recursive stored procedures in my 8.0.4 Database. When I migrated my 8.0.4 Database to 8.0.5 all these procedures have become invalid and also my DBMS_OUTPUT package has become invalid. I tried to compile these stored procedures and DBMS_OUTPUT package and it gave me the following errors.

ORA-04045: errors during recompilation/revalidation of SYS.DBMS_OUTPUT ORA-01000: maximum open cursors exceeded

After I got the above errors I adjusted my open_cursors parameter to a higher value, even then it didn't compiled.

Please let me know if you have any suggestions regarding this problem.

Thanks in advance

Prasanti. Received on Thu Mar 04 1999 - 01:43:53 CST