Re: association operator (=>) and SQL

No, you can't -- because you are now in the SQL world :-) so just specify "select greeting('Joe') from dual" and it will do the trick...

Cheers,
Lex.

> 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

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