Assignment $10-2$: Using theDBMS$\_$DDLPackageBecause Brewbean$$s is in the middle of constructing its application and making severaldatabase modifications, the developers are going to build a procedure to recompile all invalidobjects automatically$\mathrm{.}1.$ Start SQL Developer, if necessary$\mathrm{.}2.$ Type and run the following code:SELECT object$\_$name, statusFROM user$\_$objectsWHERE object$\_$type $=$'PROCEDURE';$3.$ If you see theBB$\_$JOBTESTprocedure listed with aVALIDstatus onscreen, skip to Step $7.$If this procedure doesn$$t exist, proceed with Step $4\mathrm{.}4.$ Open theassignment$02.$txtfile in the Chapter$10$ folder, and use its code to create theBB$\_$JOBTESTprocedure.

$5.$ Type and run the following code:SELECT object$\_$name, statusFROM user$\_$objectsWHERE object$\_$type $=$'PROCEDURE';$6.$ Verify that the query results listBB$\_$JOBTESTwith aVALIDstatus, which tells you theprocedure exists$\mathrm{.}7.$ Type and run the following statement to modify the BB$\_$JOBQ table. Because theBB$\_$JOBTESTprocedure uses this table, the procedure changes to the statusINVALID,indicating the need for recompiling.ALTER TABLE bb$\_$jobqMODIFY $($msg VARCHAR$2(30))$;$8.$ Type and run the following query to confirm the statusINVALID:SELECT object$\_$name, statusFROM user$\_$objectsWHERE object$\_$type $=$'PROCEDURE';$9.$ Create an anonymous block, using DBMS$\_$DDL$.$ALTER$\_$COMPILE to compile all INVALID objects using an IF THEN ELSE LOOP. To simplify this process, retrieve all the INVALID objects in a cursor. Run the anonymous block$\mathrm{.}10.$ Type and run the following query to confirm that these objects$$ status is nowVALID:SELECT object$\_$name, statusFROM user$\_$objectsWHERE object$\_$type $=$'PROCEDURE';