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@xxxxxxxxxxxxxx]
Sent: Friday, April 15, 2005 3:04 PM
To: Katz.C@xxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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

Other related posts: