# 22. Virtuoso Functions Guide - trace_status

Chapter Contents | Prev | Next
Keyword Search:
www.openlinksw.com
docs.openlinksw.com
Book Home
Contents
Preface
Virtuoso Functions Guide
Administration
db.dba.vacuum
user_change_password
user_create
user_drop
user_get_option
user_grant_role
user_revoke_role
user_role_create
user_role_drop
user_set_option
user_set_qualifier
cfg_item_count
cfg_item_name
cfg_item_value
cfg_section_count
cfg_section_name
cfg_write
checkpoint_interval
disconnect_user
fk_check_input_value...
log_enable
log_text
prof_enable
prof_sample
status
sys_lockdown
sys_stat
system
trace_status
user_set_password
virtuoso_ini_path
Aggregate Functions
Array Manipulation
BPEL APIs
Backup
Compression
Cursor
Date & Time Manipulation
Debug
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_status

show current trace settings
voidtrace_status
Description

You must have DBA privileges to run that function.

This function returns an array of all available trace options and current status of the traces.

Examples
Example

This is to show the current state of all trace log options.

    SQl> create procedure trace_status_show ()
       {
         declare i, l integer;
         declare opt, status varchar;
         declare arr any;
         arr := trace_status();
         i := 0; l := length (arr);
         result_names (opt, status);
         while (i < l)
           {
    	 result (arr[i], arr[i+1]);
             i := i + 2;
           }
       };

    SQL> trace_status_show();
    opt                       status
    VARCHAR                   VARCHAR
    _______________________________________________________________________________

    user_log                  off
    failed_log                off
    compile                   on
    ddl_log                   off
    client_sql                off
    errors                    off
    dsn                       off
    sql_send                  off
    transact                  on
    remote_transact           off
    exec                      off
    soap                      off

See Also

trace_on()

trace_off()