title: how to write loop for a record type in oracle
body: <p>I have the following statement which compiles fine in my package:</p>
  
  <p>package header:</p>
  
  <pre><code>   TYPE role_user_type IS RECORD (
        ROLE_ID        some_table.ROLE_ID%TYPE,
        SUBGROUP       some_table.USER_ID%TYPE
     );
  </code></pre>
  
  <p>body:</p>
  
  <pre><code>ROLE_USER_REC                  MY_PACKAGE.ROLE_USER_TYPE;
  
  SELECT B.USER_ID, B.ROLE INTO ROLE_USER_REC
  FROM some_table where user_id like 'M%'
  </code></pre>
  
  <p>what is the skeleton for looping through <code>ROLE_USER_REC</code>? can we even loop through it?</p>