Hi Owen,P_USER is a Range structure. You can simply use it as follows:SELECT * INTO CORRESPONDING FIELDS OF TABLE ITAB_USER_ROLES WHERE UNAME IN P_USER.