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
RDF data
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()