Ok, i know im suppose to create a procedure with 3 parms, i did that my problem is knowing what im suppose to do in my Anomyous block once this is created.

Here are the instructions

Procedure Rent_SP takes in 3 parms, id, member_id, and inv_id. It adds a new record to the rental table. It should also update the movie inv, which is movie_qty column of the movie table.

Procedure return_sp takes in 2 parms, movie and member. Based on the indicated values it identifies rental record from the rental table and records date in the check_date column. It also needs to update movie inventory in the movie table.

Any help with logic will help, thanks.