Terrible BUG in PL/SQL's block in Oracle !!!

From: Alex A.Timofeev <tim_at_mct.spb.su>
Date: Wed, 10 Nov 1993 10:10:00 GMT
Message-ID: <AAutBuiWQ1_at_mct.spb.su>

Hello,

  I have a serious problem with Oracle Server for NetWare v6.0.36.1.0.   (and ORACLE RDBMS for DOS v6.0.34...)
  For example, next PL/SQL block not working properly (other words,   i have full crash of NetWare file server):

create table d( d date);
declare

  d_a constant date :='12-nov-93';


/*    ^^^^^^^^  BUG HERE !!!  */

  d_b date ;
begin
 d_b := d_a;
 insert into d values(d_a);
 commit;
end;
/

  If i remove keyword "CONSTANT", then it working normally!

create table d( d date);
declare
  d_a date :='12-nov-93';
  d_b date ;
begin
 d_b := d_a;
 insert into d values(d_a);
 commit;
end;
/

  Is it BUG or UNDOCUMMENTED FEATURE :( ???

Alexey Timofeev, ICT, St.Petersburg, Russia. (tim_at_mct.spb.su)

P.S. I hope, you've understood my English. Received on Wed Nov 10 1993 - 11:10:00 CET