Database Administration Oracle

***create a named procedure named DDI.DISPLAY_ROOMCNT***

- Set echo on

- Set SERVEROUT ON FORMAT TRUNCATED

- Set up a spool file to receive your output for submission. I would suggest c:\cs423\S3project2spool.txt

- Create a copy of c:\cs423\S2project1.txt as c:\cs423\S3project2.txt and change the DECLARE block to a CREATE OR REPLACE PROCEDURE named DDI.DISPLAY_ROOMCNT

- Modify the loop to use a cursor

- Compile and run your report

(If there are errors, SHOW ERRORS to see what needs to be corrected)

- Run the procedure using the SQL EXEC statement.

- Close the spool file