Name

trace_status — show current trace settings

Synopsis

void trace_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 24.423. 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