RE: association operator (=>) and SQL

Thanks Lex,
We're working with an overloaded Oracle supplied function. If we don't specify the parameter name we get another error. But we'll try to stay in pl/sql.
Thanks again
chaim

-----Original Message-----
From: Lex de Haan [mailto:lex.de.haan_at_naturaljoin.nl] Sent: Friday, April 15, 2005 3:04 PM
To: Katz.C_at_forces.gc.ca
Cc: oracle-l_at_freelists.org
Subject: 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