Allow for large text in the "TEXT" field and auto move it to "EXTRA" if necessary

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

Allow for large text in the "TEXT" field and auto move it to "EXTRA" if necessary #17

Closed martindsouza closed 11 years ago

martindsouza commented 11 years ago

From Juergen:

The other enhancement I made was our developers don't have to know if the message they want to log are > 4K, so logger.error(my_variable); looks if my_variable is > 4K and automatically stores it in the extra column together with a short hint in the text column that the text is too long and can be found in the extra column

Note: We already do something similar for the log_params functionality.

martindsouza commented 11 years ago

For now this has been done to convert large varchar2 (up to 32767) to the EXTRA column if it exceeds 4000 characters. May look at converting to clobs in future but need to test performance.

martindsouza commented 9 years ago

This issue was moved to OraOpenSource/Logger#17