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 (See ORA-00907.ora-code.com): missing right parenthesis
