rel 3 giving problems

[deswal_aja]

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>
SQL> conn test/cfsl
Error accessing package DBMS_APPLICATION_INFO
ERROR:
ORA-06553: PLS-707: unsupported construct or internal error [2603]

----------------------------


SQL> select * from dba_segments
2 *
3 ERROR at line 1:
4 ORA-06544: PL/SQL: internal error, arguments: [2603], [], [], [], [], [], [], []
5 ORA-06553: PLS-707: unsupported construct or internal error [2603]
6

[dknight]

I had a related problem a few days ago. It may be related to the installation.

Try this:

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.

Good luck

[deswal_aja]

thank you dave

i'll apply you suggestion on dev db.
for now i've removed rel3 and installed rel2.