Re: Bug in ORACLE 7.0.16.6.0 - PL/SQL 2.0.18.1.0 referencing view with NULL column in stored procedure.

l.carl.pedersen_at_dartmouth.edu (L. Carl Pedersen) writes:
: 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>
Looks like bug 175095, fixed in 7.1.3.

--
regards,
Carl
+-----------------------------------------------------------------------------+
Carl Gohringer, 
Oracle UK, The Oracle Centre, The Ring, Bracknell, Berkshire, England, RG121BW
Internet   : cgohring_at_uk.oracle.com    
+-----------------------------------------------------------------------------+