association operator (=>) and SQL
- From: Katz.C@xxxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 15 Apr 2005 14:38:44 -0400
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
