Can Someone help me with the logic for this Procedure
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.
I believe that we have already helped you with this homework assignment. If you keep getting other people to do your work you will never learn. Code this in pieces. Get the first requirement and write code that will do this, and then add a little more. You should also look at PL/SQL Best Practices by Stephen Feuerstein. This will give you more concrete examples on writing good code.
Originally Posted by LKBrwn_DBA
this space intentionally left blank
Since you have already created the procedure, why are you listing the processing requirements for it, and why is the title of the thread "Can Someone help me with the logic for this Procedure?"
Originally Posted by epsonC84
Do you want help in writing the procedure that you've already got, or in calling it from an anonymous block?
Originally Posted by WilliamR
Your right, i need help writing the block. Those are the instructions, and i have no clue how to start it
Originally Posted by gandolf989
thanks for the book reference sir. I'll have to check it out.
You may need to set up some test data (a member with ID = 123, etc).
rent_sp(123, 456, 789);
Click Here to Expand Forum to Full Width