I have to make stored procedure

I am using the oracle sql developer plz answer through the oracle sql developer 

Transcribed Image Text:

Write a stored procedure called staff_add that will add a new row to the STAFF table as described below: - - - - ID - should be calculated as 10 higher than the highest ID currently in the STAFF table NAME - must be provided as input DEPT - set this automatically to 90 JOB - must be provided as input; must be either "Sales" or "Clerk" or "Mgr" -anything else should cause an error YEARS - set this automatically to 1 SALARY - must be provided as input COMM - must be provided as input WHAT TO HAND IN: A copy of your stored procedure and the output of a successful insert, and error handling Write a stored procedure called staff_add that will add a new row to the STAFF table as described below: - - - - ID - should be calculated as 10 higher than the highest ID currently in the STAFF table NAME - must be provided as input DEPT - set this automatically to 90 JOB - must be provided as input; must be either "Sales" or "Clerk" or "Mgr" -anything else should cause an error YEARS - set this automatically to 1 SALARY - must be provided as input COMM - must be provided as input WHAT TO HAND IN: A copy of your stored procedure and the output of a successful insert, and error handling