In Procedure Builder, create a procedure named ADD_PROJ_MGR that receives input parameters of the project ID, a consultant ID, and a project duration (in months), and then uses these values to insert a new record into the PROJECT_CONSULTANT table. Use the current system date for the roll-on date, and use the ADD_MONTHS function to calculate the roll-off date. Initialize the project hours to zero.
roll_on_date is a field in a table
roll_off_date is a field in a table
Thanks for any assistance you can provide.
this assignment is from Chapter 5 Lesson B Problem-Solving cases
Advance PL/SQL Programming