DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2001
    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 [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]

  2. #2
    Join Date
    Oct 2000
    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

  3. #3
    Join Date
    Mar 2001

    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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.