Configuration Command

Control verbose error reporting.

verbose {on|off} 

Description

Verbose error reporting displays more information about the nature of a SQL error than the message usually printed. Because it allows you to turn verbose error reporting on or off, this command is useful when testing query syntax and is recommended for development only.

The default setting is off.

Oracle Only

When you turn verbose error reporting off, only the ORACLE error code is returned (following the specified error string). When you turn it on, the text of the ORACLE error message is also output.

Example

send "verbose on\n" to SQL

See Also

error Command