title: Calling an Oracle function in mule 4
body: <p>How do I get the return value from an Oracle funtion with named parameters? </p>
  
  <p>I am using</p>
  
  <pre><code>&lt;db:stored-procedure doc:name="Stored procedure" doc:id="607a27d0-0738-406b-900d-9490e3026c9a" config-ref="Database_Config"&gt;
          &lt;db:sql &gt;:result = call ib_gate.Listen_New(:i_Command,:i_Client_Id,:i_Params,:o_Err_Code,:o_Err_Msg)&lt;/db:sql&gt;   
          &lt;db:input-parameters &gt;&lt;![CDATA[#[{'i_Command' : 'GET_DATA','i_Client_Id' : -1,'i_Params' : 'ID:386075'}]]]&gt;
          &lt;/db:input-parameters&gt;
          &lt;db:output-parameters&gt;
              &lt;db:output-parameter key="result" type="VARCHAR"/&gt;
              &lt;db:output-parameter key="o_Err_Code" type="VARCHAR"/&gt;
              &lt;db:output-parameter key="o_Err_Msg" type="VARCHAR"/&gt;
          &lt;/db:output-parameters&gt;
  &lt;/db:stored-procedure&gt;
  </code></pre>
  
  <p>but this return an error <em>ORA-00900: invalid SQL statement</em></p>