DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: rel 3 giving problems

  1. #1
    Join Date
    Mar 2001
    Posts
    65
    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

  2. #2
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    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
    Posts
    65


    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