Question

Project 6-Printing a Formatted Report Printing a formatted report from the DDI.LEDGER_VIEW USING Head of Forms, Form Breaks, and an End of Form 70.

Requirements: Build a report using the ledger view I would like you use at least 4 techniques you have learned in this course such as Any Report formatting techniques Any Data formatting techniques

Any Error handling techniques

Any OOP techniques such as data types.

Any Cursor techniques USING Head of Forms, Form Breaks <- are not included in the above , these are required by default. ( Head of Forms, Form Breaks) + the 4 techniques mentioned about.

This assignment is an open ended assignment to exercise what you have learned and to show off your favorite features of the PL/SQL scripting language.

Answer 1

I don't see any issue with your PL/SQL code. However please take care of the below points in order to resolve your issue.

Point 1: please consider formatting your output using the below commands before executing the PL/SQL code.

Set lines 200 pages 300

If formatting of a column is required, please do that,

e.g., col last for a 10. By doing this, your output will be displayed in a better and more readable manner.

Point 2 : for spooling, you need to do the following:

SQL>spool project5spool.txt

SQL>DECLARE............

SQL>spool off;

By doing this, you will get a text file with name

Project5spool.txt in your O.S pwd(present working directory)