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.

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen