GET_TRACE_VALUE
Use this procedure to programmatically retrieve the current value of a trace.
Syntax
CTX_OUTPUT.GET_TRACE_VALUE(trace_id BINARY_INTEGER);trace_id
Specify the trace ID whose value you want. See Table 11-1 for possible values.
Example
This sets the value of the variable value:
value := ctx_output.get_trace_value(trace_id);Notes
You can also retrieve trace values through SQL:
select * from ctx_trace_values;See “CTX_TRACE_VALUES” for the entries in the CTX_TRACE_VALUES view.
If the trace has not been enabled, an error is raised.
Traces are not reset to 0 by this call.
Traces are associated with a session-they can measure operations that take place within a single session, and conversely, cannot make measurements across sessions.