Database Administration

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. The result should be the same as last week

Close the spool file