SPOOL your output to ccs422aproject4spooltxt Set up a record

SPOOL your output to c:\\cs422a\\project4spool.txt

Set up a record variable in the DECLARE section using %ROWTYPE

SELECT all the fields in DDI.LEDGER_VIEW where ROOMNUM is 107

Use DBMS__OUTPUT.PUT_LINE to print the values for each field for each record.

How Do I Compile and run the procedure?

Solution

For SPOOL related error Enter SPOOL with no clauses to list the current spooling status.
To spool output generated by commands in a script without displaying the output on the screen,
use SET TERMOUT OFF. SET TERMOUT OFF does not affect output from commands that run interactively.
make sure you use quotes around file names containing white space.

Also try Typing SET SERVEROUTPUT ON in SQL*Plus has the effect of invoking
DBMS_OUTPUT.ENABLE (buffer_size => NULL); with no limit on the output.
You should generally avoid having application code invoke either the DISABLE Procedure or
ENABLE Procedure because this could subvert the attempt of an external tool like SQL*Plus
to control whether or not to display output.