association operator (= >) and SQL 2005-04-15 - By Katz.C@(protected)
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@(protected)]
Sent: Friday, April 15, 2005 3:04 PM
To: Katz.C@(protected)
Cc: oracle-l@(protected)
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 (See ORA-00907.ora-code.com): missing right parenthesis
--
http://www.freelists.org/webpage/oracle-l
|
|
