association operator (=>) and SQL

From: <Katz.C_at_forces.gc.ca>
Date: Fri, 15 Apr 2005 14:38:44 -0400
Message-Id: <20050415184026.A9B072AB602@mx04.forces.gc.ca>

Hello,
Can we use this named notation syntax when calling a PL/SQL function in an SQL statement.

It doesn't seem to work, (but maybe I'm doing something wrong (Oracle 9.2.0.4 on windows))

SQL> create function greeting (p_name varchar2)   2 return varchar2
  3 is
  4 begin
  5 return 'Hello '||p_name;
  6 end;
  7 /

Function created.

SQL> select greeting(p_name=>'Joe')
  2 from dual;
select greeting(p_name=>'Joe')

                      *

ERROR at line 1:
ORA-00907: missing right parenthesis

Thanks,
chaim  

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Apr 15 2005 - 14:42:48 CDT