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


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