SQL Navigator for Oracle 7.4 - Installation Notes

Chat now with support

The DBMS_OUTPUT package is a standard package provided by Oracle specifically for the purpose of debugging stored programs.

Feature	Description
Insert a DBMS_OUTPUT.PUT_LINE statement in the code	Edit Menu \| Insert \| DBMS_OUTPUT.PUT_LINE ('')
Create a DBMS_OUTPUT.PUT_LINE statement for the selected variable in the editor.	In the Code Editor Place the cursor on the variable. Click Edit \|Insert \| Debug Variable. The debug statement is generated and copied to the clipboard. Place the curser where you would like to insert the debug statement in your code. Click Edit \| Paste.
Capture output from DBMS_OUTPUT	The SQL Navigator Output Window captures output from DBMS_OUTPUT.

Feature

Description

Insert a DBMS_OUTPUT.PUT_LINE statement in the code

Edit Menu | Insert | DBMS_OUTPUT.PUT_LINE ('')

Create a DBMS_OUTPUT.PUT_LINE statement for the selected variable in the editor.

Place the cursor on the variable.
Click Edit |Insert | Debug Variable. The debug statement is generated and copied to the clipboard.
Place the curser where you would like to insert the debug statement in your code. Click Edit | Paste.

Capture output from DBMS_OUTPUT

The SQL Navigator Output Window captures output from DBMS_OUTPUT.

Note: The SYS schema owns this package. To view the procedure and parameter definitions of this package you can display it in the Code editor.