-
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
-
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
David Knight
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|