Database Software

1. CREATEORREPLACEFUNCTION my_function (p_param number)RETURN varchar2 IS begin RETURN'value_'||p_param; end;
2. FUNCTION created.
4. SELECT my_function(1)FROM dual;
6. MY_FUNCTION(1)
7. --------------------------------------------------------------------------------
8. value_1                                                                      
9. 1 row selected.
11. -- I want this to work
12. SELECT my_function(p_param=> 2)FROM dual;
14. SELECT my_function(p_param=> 2)FROM dual
15.                           *
16. Error at line 1
17. ORA-00907: missing RIGHT parenthesis

bye

TPD