Problems with CATPROC.SQL
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$ iwhere 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 ColumbiaReceived on Thu Dec 15 1994 - 01:37:00 CET