Server Output Tutorial

SQLXP Server Output Tutorial
This tutorial shows how to use server output to help you debug your PL\SQL blocks, functions, procedures, and packages. 1. Open a command window. 2. Enter a PL\SQL block statement that contains calls to dbms_output.putline, the calls can be in the block directly or in a procedure, function, or package being called by the block. 3. In the output tab Check the Enable Oracle output box and set the buffer size big enough to handle the output from the database server. 4. Click the execute button. 5. In the output tab you will see an Oracle Output header and below it the text passed to the dbms_output.putline procedure.
© 2002 Netlegger Systems. All rights reserved.

SQLXP

This tutorial shows how to use server output to help you debug your PL\SQL blocks, functions, procedures, and packages.

1. Open a command window.
2. Enter a PL\SQL block statement that contains calls to dbms_output.putline, the calls can be in the block directly or in a procedure, function, or package being called by the block.
3. In the output tab Check the Enable Oracle output box and set the buffer size big enough to handle the output from the database server.
4. Click the execute button.
5. In the output tab you will see an Oracle Output header and below it the text passed to the dbms_output.putline procedure.