Problems with CATPROC.SQL

From: Peter Grant <grant_at_devbn1.triumf.ca>
Date: 14 Dec 1994 16:37 PST
Message-ID: <14DEC199416375785_at_devbn1.triumf.ca>


First, the versions:

OpenVMS 5.5-2H4
ORACLE7 Server Release 7.0.16.6.2 - Production With the procedural option
PL/SQL Release 2.0.18.1.2 - Production

Stored procedures couldn't be defined, so I tried running CATPROC to redefine everything.

When CATPROC executes, it runs into a number of errors.

The most serious errors are in the file DBMSSTDX.SQL when defining the DBMS_STANDARD package, it returns...

      27
      27    -- Override call in standard
      28    procedure sql_ddl(stmt varchar2);
      29  end;
      30  /
     create package dbms_standard is
     *
     ERROR at line 1:
     ORA-00602: internal programming exception
     %SYSTEM-F-ACCVIO, access violation, reason mask=!XB, virtual address=!XL,
     PC=!XL, PSL=!XL

And, of course, nothing from this point on works.

The first errors were in the file CATRPC.SQL

..

create or replace view ORA_KGLR7_IDL_UB1   (OWNER, NAME, TYPE, PART, VERSION, PIECE#, LENGTH, PIECE) as
select /*+ index(i i_idl_ub11) +*/

       o.owner, o.name, o.type, i.part, i.version,
       i.piece#, i.length, i.piece
from sys.ora_kglr7_objects o, sys.idl_ub1$ i
where o.object_id = i.obj#
..

But, the table IDL_UB1$ doesn't have a "version" column. Details, details...

This is also true for the views ORA_KGLR7_IDL_CHAR, ORA_KGLR7_IDL_UB2, and ORA_KGLR7_IDL_SB4. Any hints?

Peter Grant, BSc, ISP ////////  ///////  ////////  //    //  //    //  ////////
grant_at_devbn1.triumf.ca  //     //    //     //    //    //  ///  ///  //
                       //     ///////      //    //    //  ////////  ///////
                      //     //  //       //    //    //  // // //  //
                     //     //    //  ////////  //////   //    //  //
                                               Canada's National Meson Facility
__________________________________________ _        Vancouver, British Columbia
Received on Thu Dec 15 1994 - 01:37:00 CET

Original text of this message