title: Calling a function with user defined type parameters (Oracle ODP.NET)
body: <p>I'm using a function : </p>
  
  <pre><code>fu_has_permissions(udt_person('johny','superman'),'fly_away')
  </code></pre>
  
  <p>udt_person is a user defined type :</p>
  
  <pre><code>create or replace TYPE udt_person AS OBJECT 
  (name VARCHAR2(3), 
  id VARCHAR2(18));
  </code></pre>
  
  <p>I want to use bind variables whan calling this function, but i'm not really sure what am i doing wrong ... Here's the code : </p>
  
  <pre><code>......
  OracleParameter udtPersParam = new OracleParameter();
  udtPersParam.ParameterName = ":pUdtPers";
  udtPersParam.UdtTypeName = "UDT_PERS";
  string[] paramValues = { name, id };
  udtPersParam.Value = paramValues;
  OracleParameter pAction = new OracleParameter(":pAction", OracleDbType.Varchar2, 255);
  pAction.Value = action;
  
  parameters.Add(udtPartParam);
  parameters.Add(pAction);
  
  try
  {
  _loginOdr = DBFacade.ExecuteSelectQuery("select fu_has_permissions(:pUdtPart, :pAction) from dual", parameters);
  }
  </code></pre>
  
  <p>Thanks!</p>