Notes

--creating the cursor named as proc_exp_tickets_cursor
CREATE OR REPLACE PROCEDURE proc_exp_tickets_cursor(in_duration tickets.duration%TYPE) IS
cursor cur_duration IS
SELECT ticket_id,band_name,description,title, duration FROM tickets WHERE duration>= in_duration;
rec_cur_duration cur_duration%ROWTYPE;
BEGIN
OPEN cur_duration;
FETCH cur_duration INTO rec_cur_duration;
IF cur_duration %NOTFOUND THEN
DBMS_OUTPUT.PUT_LINE('no duration data not found.');
ELSE
WHILE cur_duration%FOUND LOOP
DBMS_OUTPUT.PUT_LINE('ID='||rec_cur_duration.ticket_id||' Music type : '||rec_cur_duration.title||' Band : '||rec_cur_duration.band_name);
FETCH cur_duration INTO rec_cur_duration;
END LOOP;
END IF;
END proc_exp_tickets_cursor;
/
SHOW ERRORS

--Testing cursor proc_exp_tickets_cursor which gives the data by insering the duration.
EXEC proc_exp_tickets_cursor(2021);
--it display th ticket id name , title with the given durations .
--one row selected
EXEC proc_exp_tickets_cursor(2019);

EXEC proc_exp_tickets_cursor(2033);
--no duration availabe, message is not found .