-- John Wilkinson (MS50)
-- Databases (COMS 30103) - Dr. J.Gallagher
-- Video Shop - Assignment 2
------------------------------------------------------------------------
-- Harness used in developing/testing: Question 1
------------------------------------------------------------------------


BEGIN
        -- call stored procedure: Question 1
        -- the user is prompted for a value for video
        
        rentVideo('&video_title', '&member_id');
       
END;
/
select * from message_s;
delete from message_s;