Notes

--
CREATE OR REPLACE PROCEDURE proc_cursor_festival(in_festivals festivals.festival_name%TYPE) IS
BEGIN
DELETE FROM tickets WHERE festival_name = in_festivals;
IF(SQL%FOUND) THEN
DBMS_OUTPUT.PUT_LINE(in_festivals || 'is DELETED!!');
ELSE
DBMS_OUTPUT.PUT_LINE('NO SUCH FESTIVAL IS FOUND');
END IF;
END proc_cursor_festival;
/
SHOW ERRORS;

--
CREATE OR REPLACE PROCEDURE proc_cursor_provision(in_provision VARCHAR2) IS
BEGIN
DELETE FROM provision t WHERE t.address.country = in_provision;
IF(SQL%NOTFOUND) THEN
DBMS_OUTPUT.PUT_LINE('NO SUCH PROVISION WITH COUNTRY ' || in_provision || ' IS FOUND');
ELSE
DBMS_OUTPUT.PUT_LINE('PROVISION WITH COUNTRY' || in_provision || ' IS DELETED');
END IF;
END proc_cursor_provision;
/
SHOW ERRORS;


--
CREATE OR REPLACE PROCEDURE proc_cursor_loc_provision IS
vn_no_of_rows NUMBER(2);
BEGIN
SELECT location_id FROM location_provision;
vn_no_of_rows := SQL%ROWCOUNT;
DBMS_OUTPUT.PUT_LINE('THERE ARE ' || vn_no_of_rows || ' number of rows.');

END proc_cursor_loc_provision;
/
SHOW ERRORS;