Martin Giffy D'Souza

Dynamically find function/procedure name

2

From @jaughenbaugh Could use this code to find the current function/procedure name in a package. Need to think about efficiency though and make it optional. Also if in no-op skip...

SQLERRM isn't being logged

2

`SQLERRM` should be logged (via `dbms_utility.format_error_backtrace`) but it isn't. Simple test case: ``` plsql create or replace procedure p_test as l_temp pls_integer; begin raise_application_error(-20001, 'todo'); select 1 into l_temp from...

_From @martindsouza on July 27, 2013 1:59_ As a result for issue #17 A current workaround for large text entries in p_text is to move it to the EXTRA column....

Look into EBS Logger Code

1

From https://github.com/tmuth/Logger---A-PL-SQL-Logging-Utility/pull/82 Link to file: https://github.com/tmuth/Logger---A-PL-SQL-Logging-Utility/files/282501/xx_ebs_logger.zip

Test case: set level = error. Then log apex items and see what happens...

Remove the `releases` folder as the tags should be sufficient with for each release.

https://github.com/tschf/oracle-ci-guide

In some situations you may want to avoid logging for a given procedure or only log a given proc. Session specific logging helps but doesn't solve this problem. See if...

Try setting this in a global value as `&APP_ID..&PAGE_ID.` or use the application process technique.

See http://krisrice.blogspot.com/2016/02/sqlcl-monitoring-itself-with-longops.html for details.