title: How to call a function in select statement which is having OUT parameter in it?
body: <p>If i have a function with OUT parameters then how can we call that function in  select statement.<br>
  my function is as below</p>
  
  <pre><code>CREATE OR REPLACE FUNCTION fun_1 (p_in IN VARCHAR2, p_out OUT NUMBER)
  RETURN number
  AS
  BEGIN
  SELECT SAL INTO p_out FROM emp WHERE ename=P_in;
  RETURN p_out;
  END;
  </code></pre>
  
  <p>i want to call that function through select statement as below.</p>
  
  <pre><code>select fun_1('KING', lv_var) from dual;
  </code></pre>
  
  <p>is it possible. ?</p>