logger vs debugf

[database-craftsman]

We have been with debug.f for 5 years. There 2 good features that logger doesn't have.

1. tail -f debug_trace_file.
2. debug.f("%s rows update on table %s", l_count, l_table_name);

As C printf: It can optionally contain embedded format specifiers that are replaced by the values specified in subsequent additional arguments and formatted as requested.

Below code with logger to print local variables is awkward, it's not as flexible as debug.f("%s",l_abc). when I want to print different set of variables at each time, I have to add and delete some elements in array l_params.

logger.append_param(l_params, 'p_param1_todo',p_param1_todo);
logger.log('START', l_scope, null, l_params);

There is some workaround for "tail -f".

Can we add feature of replacing print variable like printf("%s",l_abc) to next release?

This feature request is same as issues 32, Substitution Strings :
#32

C printf format is easier to use, better than logger.log('Employee %P_EMPNO%', p_params => l_params, p_do_substitutions => true). Less code. ^_^

Thanks,
Charlie

[martindsouza]

This will be implemented in release 2.2.0. Going to mark this ticket as closed and keep all the comments in #32

[martindsouza]

This issue was moved to OraOpenSource#59