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

Open From: Edit Menu | Insert | DBMS_OUTPUT.PUT_LINE ('')

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating