plsql - how to write loop for a record type in oracle - Stack Overflow
I have the following statement which compiles fine in my package: package header: TYPE role_user_type IS RECORD ( ROLE_ID some_table.ROLE_ID%TYPE, SUBGROUP ... You can use a cursor FOR loop: BEGIN FOR role_user_type IN ('SELECT B.USER ......