Database Administration Oracle ***create a named procedure named DDI.DISPLAY_ROO

Question

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:cs423S3project2spool.txt

- Create a copy of c:cs423S2project1.txt as c:cs423S3project2.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

Explanation / Answer

CREATE PROCEDURE DDI.DISPLAY_ROOMCNT

IS

l_file UTL_FILE.file_type;

l_file_name VARCHAR2 (60);

BEGIN

Set echo on

Set SERVEROUT ON FORMAT TRUNCATED

l_file := UTL_FILE.fopen ('UTL_DIR', l_file_name, 'w');

END;

EXECUTE DDI.DISPLAY_ROOMCNT (UTL_FILE.FOPEN,'c:cs423S3project2spool.txt');

CREATE OR REPLACE PROCEDURE DDI.DISPLAY_ROOMCNT

IS

l_file UTL_FILE.file_type;

l_file_name VARCHAR2 (60);

BEGIN

l_file := UTL_FILE.fopen ('UTL_DIR', l_file_name, 'w');

UTL_FILE.putf (l_file, l_file_name);

UTL_FILE.fclose (l_file);

END DDI.DISPLAY_ROOMCNT;

EXECUTE DDI.DISPLAY_ROOMCNT(UTL_FILE.FOPEN,'c:cs423S3project2.txt');

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.