Skip to Main Content

allow named parameters in functions calls within SQL

TPD-OpitzApr 3 2015 — edited Jan 11 2016
  1. CREATEORREPLACEFUNCTION my_function (p_param number)RETURN varchar2 IS begin RETURN'value_'||p_param; end;
  2. FUNCTION created.
  3. SELECT my_function(1)FROM dual;
  4. MY_FUNCTION(1)
  5. --------------------------------------------------------------------------------
  6. value_1                                                                      
  7. 1 row selected.
  8. -- I want this to work
  9. SELECT my_function(p_param=> 2)FROM dual;
  10. SELECT my_function(p_param=> 2)FROM dual
  11.                           *
  12. Error at line 1
  13. ORA-00907: missing RIGHT parenthesis

bye

TPD

Comments
Post Details
Added on Apr 3 2015
3 comments
483 views