{"id":305,"date":"2009-02-17T23:14:29","date_gmt":"2009-02-17T22:14:29","guid":{"rendered":"http:\/\/bar-solutions.com\/wordpress\/?p=305"},"modified":"2009-02-17T23:14:29","modified_gmt":"2009-02-17T22:14:29","slug":"overloading-and-parameters","status":"publish","type":"post","link":"https:\/\/blog.bar-solutions.com\/?p=305","title":{"rendered":"Overloading and parameters"},"content":{"rendered":"

When you call a procedure or function in PL\/SQL you basically have two options for the parameters. By name or by position. If you use the by name<\/strong> version, then every parameter is named. You don\u2019t have to conform to the order of the parameters because Oracle<\/a> will automatically put the value in the right variable. You can even mix both approaches, start with positional notation and then switch to named notation. Be aware though that you cannot switch back. Once you\u2019re using named notation you cannot go back to positional notation.<\/p>\n

<\/p>\n

So when you create a program (procedure or function) and call this from another program you basically have three options. Consider the following procedure:<\/p>\n

\n
   1:  <\/span>create<\/span> or<\/span> replace procedure<\/span> parameter_usage<\/pre>\n
   2:  <\/span>( parama_in in<\/span> pls_integer<\/pre>\n
   3:  <\/span>, paramb_in in<\/span> pls_integer<\/pre>\n
   4:  <\/span>, paramo_out out<\/span> pls_integer)<\/pre>\n
   5:  <\/span>is<\/span><\/pre>\n
   6:  <\/span>begin<\/span><\/pre>\n
   7:  <\/span>  paramo_out := parama_in * paramb_in;<\/pre>\n
   8:  <\/span>exception<\/span><\/pre>\n
   9:  <\/span>  when<\/span> others then<\/span> paramo_out := 0;  <\/pre>\n
  10:  <\/span>end<\/span> parameter_usage;<\/pre>\n<\/div>\n