Use just, e., a simple dbms output.put line command in the body. Once this works, extend the procedures body step-by step.

Use just, e.g., a simple dbms output.put line command in the body. Once this works, extend the procedure"s body step-by step. And don"t forget to check whether a cursor has retrieved a tuple NOTFOUND and also use the commit statement to make your updates to the table Medal Table permanent. What to submit for 2c?