association operator (= >) and SQL 2005-04-15 - By Lex de Haan
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
|
|
