CORE DUMP ORACLE BUG IRIX 6.4 ORACLE 7.3.3 GRANTS

From: Matteo di Tommaso <tommaso_at_gcg.com>
Date: 1997/10/09
Message-ID: <343D4422.41C6@gcg.com>#1/1

Run this in SQL*Plus and watch SQL*Plus core dump. No explanation from ORACLE yet. If anyone else has seen this let me know.

---

create or replace package oraBug as
  function UserName return varchar2;

      PRAGMA RESTRICT_REFERENCES( UserName, WNDS, RNDS, WNPS ); end oraBug;
/

create or replace package body oraBug as

  aUser                VARCHAR2(30) := 'SYSTEM';

function UserName return varchar2 is
begin
  return(aUser);
end;
end oraBug;
/

create or replace view oracle_bug as
  select table_name T_NAME
    from all_tables
   where OWNER = oraBug.UserName;
grant select on oracle_bug to scott; Received on Thu Oct 09 1997 - 00:00:00 CDT