Viewing Server Messages and Errors

When you run a query against a database server, it returns a response to the client. There are three types of server response to an SQL query:

  • Tabular data
  • Status (info) message
  • Error

Tabular data is displayed in the data editor. Status messages and errors are logged to Output window. Errors are not only logged to Output window they are also shown in Error List window. As dbForge Fusion for Oracle uses the native Output and Error List windows of Microsoft Visual Studio, for more information please refer to the official Microsoft Visual Studio help documentation.

Using Output Window

Following image represents general view of Output window.

Output Window

Output Panes

The window can contain up to four output panes (depending on the specific product):

  • General pane contains most output messages, not only from a database server but from the application itself.
  • Data pane displays query results that are represented as a formatted text. This pane remains empty unless Redirect Data to Output Window option is set in any SQL document.
  • SQL Log pane displays all SQL queries executed by an application during the current session. But you need to turn on Write queries sent by the program to SQL Log option to see those queries. This option is located in the following path: Tools -> Options -> Devart dbForge Fusion -> Output.

Note

Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. These elements are determined by your Visual Studio edition and settings. For more information, see Visual Studio Settings.

As you can see from the above screen-shot, server errors are also logged to Output window. And you can navigate to the place of an error by double-click of from the pop-up menu.

Searching Output Messages

You can search text in Output window. To find specific text:

  1. Focus Output window.
  2. Open Find and Replace window by pressing CTRL+F.
  3. Enter search text and press ENTER or click Search button.

Using Error List Window

When something goes wrong, typically you see an error. If this is a user or database server error, such as mistyped query, in most cases you will see it in Error List window.

Here is an example of an error displayed in Error List.

Error List

Error List shows not only errors, but also warnings and informational messages which require user attention. Warning is in essence a non-blocking error. And informational message is just a user notification.

You can filter messages by type using appropriate buttons on the toolbar of Error List window.

You can navigate to the palace of an error by double-clicking it in the list or by selecting Go to Error from the shortcut menu.

How to View Errors from Current Document Only

Error List aggregates all error messages in the application. And if you have multiple open documents with errors, the error processing can quickly become awkward.

But the window has one more filter button - In Active Document. This button allows to view only those errors that are located in current document window.