Re: pl/sql greatest function

carl sorenson wrote:
>
> howdy,
>
> pl/sql is behaving as if there is not a function called
> 'greatest'.
>
> if you see my problem, please respond by email and a post,
> thanks :)
>
> carl sorenson
> university of colorado
>
> 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 serveroutput on size 2000
> SQL> begin
> 2 dbms_output.put_line(greatest(1,2));
> 3 end;
> 4 /
> begin
> *
> ERROR at line 1:
> ORA-06550: line 2, column 24:
> PLS-00201: identifier 'GREATEST' must be declared
> ORA-06550: line 2, column 3:
> PL/SQL: Statement ignored
>
> if i do 'dbms_output.put_line(1)' it works fine (prints a '1') -
>
> SQL> list
> 1 begin
> 2 dbms_output.put_line(1);
> 3* end;
> SQL> /
> 1
>
> PL/SQL procedure successfully completed.

Hi,

It is documented that not all the SQL functions are supported in PL/SQL

Look in the PL/SQL programing manual.

btw, DECODE is not supported also.

        Hadar Paiss Received on Wed May 29 1996 - 00:00:00 CEST