CREATE OR REPLACE PROCEDURE findSection (searchVal IN VARCHAR2 DEFAULT 'N241') AS CURSOR myTable IS SELECT * FROM section WHERE course = searchVal; myRow section%ROWTYPE; theOutput Varchar2(80); BEGIN FOR myRow IN myTable LOOP theOutput := myRow.sectionID || ' '; theOutput := theOutput || myRow.course || ' '; theOutput := theOutput || myRow.time || ' '; theOutput := theOutput || myRow.days || ' '; theOutput := theOutput || myRow.instructor || ' '; DBMS_OUTPUT.PUT_LINE (theOutput); END LOOP; END; /