search

tmuth / Logger---A-PL-SQL-Logging-Utility

Logger is used by Oracle developers to instrument their PL/SQL code
55 stars 145 forks source link

Issue setting client level with same session multiple times. #39

Closed martindsouza closed 11 years ago

martindsouza commented 11 years ago

The following raises an error:

exec dbms_session.set_identifier('martin_session');

exec logger.set_level('DEBUG', 'martin_session');

PL/SQL procedure successfully completed.

exec logger.set_level('DEBUG', 'martin_session');

*
ERROR at line 1:
ORA-20000: l_include_call_stack must be TRUE or FALSE DEBUG
ORA-06512: at "GIFFY.LOGGER", line 97
ORA-06512: at "GIFFY.LOGGER", line 1345
ORA-06512: at line 1

The issue is in get_pref as it only looks at logger_level for sessions where client_id is defined.

martindsouza commented 11 years ago

Resolved.

martindsouza commented 9 years ago

This issue was moved to OraOpenSource/Logger#40