title: Oracle: Select From Record Datatype
body: <p>I have a function that returns a record datatype (2 fields: ID and Name). How can I get at the data from a select statement?</p>
  
  <p>Specifically, I am trying using an OracleCommand object attempting to get the object into my C# code. I initially tried ...</p>
  
  <pre><code>CALL FUNCTION_NAME() INTO :loRetVal
  </code></pre>
  
  <p>... but I get a data type error for whatever type I use. I have also tried ...</p>
  
  <pre><code>SELECT * FROM FUNCTION_NAME()
  </code></pre>
  
  <p>... and ... </p>
  
  <pre><code>SELECT * FROM TABLE ( FUNCTION_NAME() )
  </code></pre>
  
  <p>... to no avail. I guess I am looking for ...</p>
  
  <pre><code>SELECT * FROM RECORD ( FUNCTION_NAME() )
  </code></pre>
  
  <p>... which, of course, doesn't exist.</p>
  
  <p>The only solution I have been able to come up with is to wrap this function call in another function call in which the outer function returns a TABLE of records containing this sole record. This, however, seems cumbersome and I am looking for a simpler method. Any help would be appreciated.</p>
  
  <p>EDIT: Sorry, I have also tried <code>SELECT FUNCTION_NAME() FROM DUAL</code>.</p>