title: Oracle - select a specific column from a ref cursor
body: <p>My situation:</p>
  <ul>
  <li>I have a table named Table1. It has lots of columns, one of them is Column1. I don't know the other columns, they may even change sometimes.</li>
  <li>There is a strongly typed ref cursor type which returns Table1%rowtype, named cur_Table1.</li>
  <li>I have a stored procedure named SP1 which has an out parameter of type cur_Table1. I'm calling this SP1 stored procedure from another database that only sees this stored procedure, but not the table or the type itself.</li>
  </ul>
  <p>How do I select only Column1 from the returned cursor?</p>
  <p>I know I can fetch into a record or as many variables as the cursor has columns, but I only know of one column's existence so I can't declare the complete record or correct number of variables.</p>