title: Select data from a record collection type
body: <p>I have a stored proc in oracle 11g server that has an out variable of record. I cannot edit this procedure. I am creating a function that will call the procedure and return the information in the record set. I looked at the following question asked here:  <a href="https://stackoverflow.com/questions/1020348/oracle-select-from-record-datatype">past question</a></p>
  
  <p>My Question is can I create a type of table for a record and query it directly in SQL? Or do I need to convert the record to type object and create a table type for it to query directly?</p>