Examine this procedure:

CREATE OR REPLACE PROCEDURE calculate$\_$budget

IS

v$\_$budget studio.yearly$\_$budget$\%$TYPE;

v$\_$studio$\_$rec studio$\%$ROWTYPE;

BEGIN

SELECT $*$INTO v$\_$studio$\_$rec

FROM studio

WHERE NAME $=$ 'Vince Productions';

v$\_$budget :$=$ get$\_$budget $($v$\_$studio$\_$rec.id$)$;

IF v$\_$budget $<30000000$ THEN

set$\_$budget $(11,300000000)$;

END IF;

END;

Which effect could you expect if a new column were added to the studio table?

A$.$

Since the code references $\%$ROWTYPE, no affect will be noticed.

B$.$

The CALCULATE$\_$BUDGET procedure would be marked valid and would automatically compile successfully upon the next execution.

C$.$

The CALCULATE$\_$BUDGET procedure would be marked invalid and would automatically compile successfully upon the next execution.

D$.$

The CALCULATE$\_$BUDGET procedure would be marked invalid and would automatically compile unsuccessfully upon the next execution.