BEGIN DECLARE CURSOR check_if_error IS SELECT sub_section, status_info FROM db_script_register_detail_tab WHERE module = 'COMPONENT' AND register_id = 'MARKET' AND processed_ok <> 'TRUE' AND EXISTS (SELECT 1 FROM db_script_register_tab WHERE module = 'COMPONENT' AND register_id = 'MARKET' AND processed_ok <> 'TRUE'); BEGIN FOR error_line_ IN check_if_error LOOP dbms_output.put_line('Sub Section: ' || error_line_.sub_section || ' ' || error_line_.status_info); END LOOP; END;