Chat now with support
Chat with Support

SQL Navigator for Oracle 7.4 - Release Notes

DBMS_OUTPUT

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

  1. Place the cursor on the variable.
  2. Click Edit |Insert | Debug Variable. The debug statement is generated and copied to the clipboard.
  3. 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.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating