Re: pl/sql greatest function

From: carl sorenson <sorenson_c_at_wizard.colorado.edu>
Date: 1996/05/24
Message-ID: <31A5DB90.3463_at_wizard.colorado.edu>#1/1

thanks for responses so far.

pl/sql is still behaving like there is no 'greatest' function.

i've now removed dbms_output from my little program, and double checked that there is a function called 'greatest' in the manual (p. 2-59 in the pl/sql user's guide and reference version 2.0).

here's a new program showing that function abs() works, but function greatest() doesn't:

Connected to:
Oracle7 Server Release 7.1.6.2.0 - Production Release With the distributed and parallel query options PL/SQL Release 2.1.6.2.0 - Production

SQL> set heading off
SQL> variable X number;
SQL> begin

  2 :X := abs(-2);
  3 end;
  4 /

PL/SQL procedure successfully completed.

SQL> print X

         2

SQL> begin
  2 :X := greatest(2,1);
  3 end;
  4 /
  :X := greatest(2,1);

        *
ERROR at line 2:

ORA-06550: line 2, column 9:
PLS-00201: identifier 'GREATEST' must be declared
ORA-06550: line 2, column 3:

PL/SQL: Statement ignored Received on Fri May 24 1996 - 00:00:00 CEST