Name

trace_off — Disable extra logging for Virtuoso server

Synopsis

integer trace_off ( in parameter varchar );
 

Description

You must have DBA privileges to run that function.

This function is used to disable logging of various information enabled by default with the TraceOn ini file option or with the trace_on() function.

Return Types

Upon success zero will be returned, otherwise an error is.

Errors

Table 24.82. Errors signalled by trace_off

SQLState Error Code Error Text
22005 SR323 "option" is not valid trace_off option

Examples

Example 24.421. Simple example

To show users logs to the server and failed user logs

 SQL> trace_off ('user_log', 'failed_log');

 Done. -- 0 msec.
 SQL>