Bug in ORACLE 7.0.16.6.0 - PL/SQL 2.0.18.1.0 referencing view with NULL column in stored procedure.
Date: Mon, 08 Aug 1994 14:14:10 -0500
Message-ID: <l.carl.pedersen-0808941414100001_at_kip-sn-97.dartmouth.edu>
ORACLE7 Server Release 7.0.16.6.0 with PL/SQL 2.0.18.1.0 blows up with an internal error when you try to create a stored procedure that references a a view that selects a NULL from some table. We're driving this on VMS.
I'd report this bug directly to Oracle via email, but they expect me to pay extra for that privilege.
$ sqlplus scott/tiger
SQL*Plus: Release 3.1.3.1.1 - Production on Mon Aug 8 13:47:16 1994
Copyright (c) Oracle Corporation 1979, 1992. All rights reserved.
Connected to:
ORACLE7 Server Release 7.0.16.6.0 - Production
With the procedural and Parallel Server options
PL/SQL Release 2.0.18.1.0 - Production
ADM> create table t as select * from dual;
Table created.
ADM> create view tv as select null x from t;
View created.
ADM> create procedure test as begin delete from tv; end;
2 /
create procedure test as begin delete from tv; end;
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [15425], [TV], [4], [1], [diana
creation], [], [], []
ORA-06552: PL/SQL: Compilation unit analysis terminated
ORA-06553: PLS-215: String length constraints must be in range (1 .. 32767)
ADM> Received on Mon Aug 08 1994 - 21:14:10 CEST