DECLARE CURSOR sel_ltd is SELECT qrr.qrr_code qrr_code,qrr.qrr_l_desc,qrr.qrr_id rqq_id FROM co_req_role_cd qrr WHERE qrr.qrr_id IN ( SELECT ltd.qrr_id FROM lgs_todo ltd WHERE TODO_OWNER = :P56_user_id AND doneyesno = 0 ) ORDER BY 1,2; BEGIN IF APEX_COLLECTION.CREATE_COLLECTION(p_collection_name => 'USER_ROLES') THEN FOR rec IN Sel_Ltd LOOP APEX_COLLECTION.ADD_MEMBER( P_COLLECTION_NAME => 'USER_ROLES', P_C001 => rec.Qrr_code, P_C002 => rec.L_Desc, P_c003 => rec.Qrr_id ); END LOOP; END IF; END;
Как извлечь курсор в коллекцию в Oracle Application Express (APEX)
schedule
24.04.2024