Question

I have to create a procedure for checking out movies and in this section of code i have to define three parameter and i am wondering if i did it right:
create or replace procedure movie_rental_sp(
mrs_movieid mm_movie.movie_id%TYPE,
mrs_memberid mm_member.member_id IN mm_member%TYPE,
mrs_paymenttype mm_pay_type.payment_method%TYPE,
mrs_movieqty mm_movie.movie_qty)
IS

Answer 1

Unfortunately, your question requires a lot of work and cannot be done for free. Submit it with all requirements as an assignment to our control panel and we'll assist you.