Re: Calling table functions using named notation returns ORA-00907 (Oracle 9i)

Named notation is only available in PL/SQL, not SQL...

create or replace function f (i number) return number as begin return i; end; /

select f(10) from dual;

     F(10)

        10

1 row selected.

select f(i=>10) from dual;

select f(i=>10)) from dual * ERROR at line 1: ORA-00907: missing right parenthesis

declare v number := f(i=>10); begin
dbms_output.put_line(to_char(v)); end; /

10

PL/SQL procedure successfully completed.

Regards

Adrian

--

Posted via dBforums
http://dbforums.com Received on Wed May 22 2002 - 01:15:26 CDT