i am finding problems with release 3 ( 8.1.7) on nt.
a simple procedure that gets compiled without errors in rel2 gives compilation warnings in rel 3.
when i change the in parameter's type to number from char it runs in rel 3 as well.
second: i performed incomplete recovery in rel3 from datafiles in rel2 instead of using impot.
i got this error on querying dba_segments and connecting as any user.
SQL> conn test/cfsl
Error accessing package DBMS_APPLICATION_INFO
ORA-06553: PLS-707: unsupported construct or internal error 
SQL> select * from dba_segments
3 ERROR at line 1:
4 ORA-06544: PL/SQL: internal error, arguments: , , , , , , , 
5 ORA-06553: PLS-707: unsupported construct or internal error 
I had a related problem a few days ago. It may be related to the installation.
1. run catalog.sql in $ORACLE_HOME/rdbms/admin
2. run dbmsstdx.sql in $ORACLE_HOME/rdbms/admin
3. run catproc.sql in $ORACLE_HOME/rdbms/admin
I found that running only catalog and catproc did not successfully create and compile the DBMS_STANDARD package.
You can view DBA_OBJECTS with owner='SYS' and object_type = 'PACKAGE' to see if the packages are valid.
OCP DBA 8i, 9i, 10g
thank you dave
i'll apply you suggestion on dev db.
for now i've removed rel3 and installed rel2.
Click Here to Expand Forum to Full Width