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$ 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
