Oracle Webserver Debugging Tips

Here are a few tips that you may find handy
when debugging your Oracle Web Server PL/SQL.

This will return the HTML that is generated by your PL/SQL package to your SQLPLUS session and/or a spool file. The HTML that the PL/SQL procedure should generate will display to the screen when you issue the owa_util.showpage. It will also be placed in the filename that you spool to (the spool is optional). You can edit the spool file, cleanup the HTML, then open your browser to the file to test your HTML syntax.
```
SET SERVEROUTPUT ON

SPOOL filename

EXECUTE package.procedure_name

EXECUTE owa_util.showpage

SPOOL OFF
```
A second option is to use the dbms_output.put_line that will generate either text strings or parameter values to your SQLPUS session immediately following an EXECUTE on your package.procedure_name These should be embedded throughout your PL/SQL code.
```
dbms_output.put_line(xxx); 
```