bug using greatest() in pl/sql user-written functions in server release 7.1.3.4.0, ORA-1403: no data found

From: L Carl Pedersen <l.carl.pedersen_at_dartmouth.edu>
Date: 1995/04/10
Message-ID: <l.carl.pedersen-1004952021190001_at_kip-2-sn-497.dartmouth.edu>#1/1

it appears that the GREATEST function does not work properly in a user-written function.

SIL> create or replace function bug return number is   2 begin
  3
  3 return greatest(1,2);
  4
  4 end bug;
  5 /

Function created.

SIL> show errors
No errors.
SIL>
SIL> select bug from dual;
select bug from dual

       *
ERROR at line 1:
ORA-01403: no data found

SIL> select * from v$version;

BANNER

---

Oracle7 Server Release 7.1.3.4.0 - Production Release PL/SQL Release 2.1.3.2.0 - Production
CORE Version 2.3.3.3.1 - Production (LSF Alpha) TNS for VMS: Version 2.1.3.0.0 - Production NLSRTL Version 2.3.4.2.1 - Production

5 rows selected.

SIL> we're on VMS 6.1. i would report this thru proper channels if oracle would allow us to do so without charging us extra. Received on Mon Apr 10 1995 - 00:00:00 CEST