TRACE_LEVEL

Description

Controls the verbosity and detail level of trace output

Type

Integer

Values

-1 to 3

Default

0

Trace levels provide increasing levels of detail:

  • -1 (ERROR_LEVEL): Error messages only

    • Critical errors

    • System failures

    • License issues

    • Connection problems

  • 0 (BASIC_LEVEL): Basic tracing

    • Function entry/exit

    • Major operations

    • Basic SQL operations

  • 1 (DETAILED_LEVEL): Detailed tracing

    • Parameter values

    • Return codes

    • SQL queries with parameters

  • 2 (DEBUG_LEVEL): Debug level tracing

    • Memory allocations

    • Buffer contents

    • Detailed timing information

  • 3 (VERBOSE_LEVEL): Verbose debug tracing

    • Internal function calls

    • Complete data dumps

    • All system operations

Implementation Notes

  • Each level includes all information from lower levels

  • Can be changed dynamically during execution

  • Performance impact increases with higher levels

  • Level 3 may significantly impact system performance