# 22. Virtuoso Functions Guide - trace_off

Chapter Contents | Prev | Next
Keyword Search:
www.openlinksw.com
docs.openlinksw.com
Book Home
Contents
Preface
Virtuoso Functions Guide
Administration
Aggregate Functions
Array Manipulation
BPEL APIs
Backup
Compression
Cursor
Date & Time Manipulation
Debug
cov_load
cov_report
cov_store
dbg_obj_print
dbg_printf
explain
pldbg_stats
pldbg_stats_load
trace_off
trace_on
Dictionary Manipulation
Encoding & Decoding
File Manipulation
Free Text
Hashing / Cryptographic
LDAP
Locale
Mail
Miscellaneous
Number
Remote SQL Data Source
Replication
SOAP
SQL
String
Transaction
Type Mapping
UDDI
User Defined Types & The CLR
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web Server & Internet
XML
XPATH & XQUERY
Functions Index

## trace_off

Disable extra logging for Virtuoso server
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

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

Examples
Simple example

To show users logs to the server and failed user logs

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

     Done. -- 0 msec.
     SQL>

See Also

trace_on()

trace_status()