title: How to call an Oracle procedure w/ OUT parameter in WSO2ESB?
body: <p>versions: 
  - WSO2 4.6.0
  - Oracle 11g</p>
  
  <p>I Have this procedure in an Oracle DB: </p>
  
  <pre><code>   PROCEDURE SEARCHCONTRACT ( CONTRACTNUM IN     OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
                                   , cur_out          IN OUT RefCursor) 
     ....
  </code></pre>
  
  <p>The procedure is working fine!</p>
  
  <p>Note that <strong>cur_out IN OUT RefCursor</strong>!</p>
  
  <p>I have no clue on how to handle that parameter in a DBLookup mediator! This mediator does not have any place to inform whether each parameter is "IN" or "OUT" and I'm not sure if setting the direction (IN/OUT) would be enough.</p>
  
  <p>Thanks in advance for any help!</p>