Suppose a procedure proc__calc_student_marks inserts the values into the student_total_marks table. If the table is modified by adding another column, what needs to be done to make the procedure valid? | PL SQL

 Oracle recompiles the procedure automatically when the procedure is invoked. Therefore, no action has to be taken if the INSERT statement is using column names. However, if the INSERT statement is just adding values without using the column names, then the procedure has to be modified, as another column has been added.