Create LICENSE.md
Create README.md
Allow aop_processor to handle large commented regions by using clobs.

Enable note_clob in logger and use it internally in aop_processor

Modified   database/LOGGER/Packages/ms_logger.pks
--Expose PROCEDURE note_clob and PROCEDURE param_clob
Modified   database/LOGGER/Packages/aop_processor.pkb
--MOD FUNCTION trim_whitespace - use CLOB
--MOD FUNCTION get_next        - use CLOB and ms_logger.note_clob
--FIX PROCEDURE AOP_pu_params  - Add whitespace to the SUPPORTED DATATYPES line search
--FIX FUNCTION AOP_var_defs    - Add whitespace to the SUPPORTED DATATYPES line search
--MOD  procedure extract_comment - use  ms_logger.note_clob
Fix AOP_pu_params

Since last change..
When reading params the comma was being consumed with the param line, causing it to lose a whole param line.

Modified   database/LOGGER/Packages/aop_processor.pkb
--MOD FUNCTION get_next - include note_clob exposing 'l_result with LF,CR,SP'
--MOD PROCEDURE AOP_pu_params - remove G_REGEX_PARAM_LINE
--     extract \W from  G_REGEX_VAR_DEF_LINE and don't consume on the initial search, but go_past later.
Modified   database/LOGGER/UnitTest/aop_test.pkb
--New test for records that are named like 'date%'
Fix unexplained value error in AOP_PROCESSOR

Cause: Index out of bounds in a var_list_typ array

Modified   database/LOGGER/Packages/aop_processor.pkb
--FIX var_list_typ - SWAPPED scale of the index and value of the array
--WAS: TYPE var_list_typ IS TABLE OF VARCHAR2(106) INDEX BY VARCHAR2(30);
--NOW: TYPE var_list_typ IS TABLE OF VARCHAR2(30)  INDEX BY VARCHAR2(106);
Fix bug param reading - now handles unsupported types correctly

Modified   database/LOGGER/Packages/aop_processor.pkb
--NEW G_COLOUR_UNSUPPORTED
--FIX AOP_pu_params -- reinstated G_REGEX_PARAM_LINE - used in i_stop, consumed in UNSUPPORTED case
--NB - further work needed. This should be expanded to cover G_REGEX_2WORDS or more, for the case of owner names etc.

Modified   database/LOGGER/UnitTest/aop_test.pkb
--New tests with unsupported param types and var types.
BUG Was adding a comment inside CASE EXPRESSIONS

Modified   database/LOGGER/Packages/aop_processor.pkb
--FIX PROCEDURE AOP_block
--Add FLAG l_exception_section
--On finding an EXCEPTION statement, set the l_exception_section flag
--Now safe to look for WHEN X THEN
Modified   database/LOGGER/UnitTest/aop_test.pkb
--New tests with Case Expressions, and Case Expression nested in Exception block.
Now handles RESULTS_CACHE RELIES ON syntax in prog unit header

Modified   database/LOGGER/Packages/aop_processor.pkb
--NEW G_REGEX_RETURN_IS_AS
--MOD PROCEDURE AOP_pu_params
--Was getting confused about the end of the params
-- get_next stop on G_REGEX_RETURN_IS_AS
-- Needed to find Return to get to end of params,
-- but now make sure we consume the IS/AS.
Modified   database/LOGGER/UnitTest/aop_test.pkb
Modified   database/LOGGER/UnitTest/aop_test.pks
--Added RESULTS_CACHE RELIES ON test.
Remove SERVER and PORT hard coding from ms_api

Modified   database/LOGGER/Packages/ms_api.pkb
Modified   database/LOGGER/Packages/ms_api.pks
--NEW CONSTANTS
--G_SMARTLOGGER_APP_NO          CONSTANT NUMBER := 104;
--G_SMARTLOGGER_PROCESS_PAGE_NO CONSTANT NUMBER := 8;
--G_SMARTLOGGER_TRACE_PAGE_NO   CONSTANT NUMBER := 24;
--NEW FUNCTION get_apex_page_URL
--NEW FUNCTION get_smartlogger_report_URL - uses get_apex_page_URL
-- If Exceptions exist so lets show them via the 'IR_REPORT_EXCEPTIONS' - uses f_process_errored
--NEW FUNCTION get_smartlogger_trace_URL - uses get_smartlogger_report_URL
--NEW FUNCTION get_smartlogger_process_URL - uses get_smartlogger_report_URL
--MOD FUNCTION get_trace_URL                - added i_server_url and i_port
--MOD FUNCTION get_user_feedback_URL        - added i_server_url and i_port
--MOD FUNCTION get_user_feedback_anchor     - added i_server_url and i_port
--MOD FUNCTION get_support_feedback_anchor  - added i_server_url and i_port
Modified   database/LOGGER/Packages/ms_logger.pkb
Modified   database/LOGGER/Packages/ms_logger.pks
--NEW FUNCTION f_process_errored - TRUE if any exceptions.
Process exception test now includes Warnings.

Modified   database/LOGGER/Packages/ms_api.pkb
--MOD FUNCTION get_smartlogger_report_URL calls f_process_exceptions
Modified   database/LOGGER/Packages/ms_logger.pkb
--MOD   FUNCTION object_owner - if object has no owner (ie not a db object) - use USER
Modified   database/LOGGER/Packages/ms_logger.pks
--RENAMED FUNCTION f_process_errored to FUNCTION f_process_exceptions and include G_MSG_LEVEL_WARNING
UNTRACKED NEW Patch: LOG-01_13A_13B_LOGGER - Supports additional features

- aop_processor:
* handles large commented regions by using clobs.
* handles RESULTS_CACHE RELIES ON syntax in prog unit header
* handles CASE EXPRESSIONS
* handles unsupported parameter types - ignores

-ms_api:
* Remove SERVER and PORT hard coding from ms_api
AOP_PROCESSOR now handles CLOB vars and Params

Modified   database/LOGGER/Packages/aop_processor.pkb
--APPEND CLOB to G_REGEX_SUPPORTED_TYPES
--MOD PROCEDURE AOP_pu_block - add param i_param_types
--MOD PROCEDURE AOP_pu_params - add param io_param_types
--MOD PROCEDURE store_var_def - stores i_param_type IN io_param_types
--MOD PROCEDURE AOP_is_as - passes empty l_param_types to AOP_pu_params then full to AOP_pu_block
--MOD PROCEDURE note_var - add param  i_type - if CLOB uses ms_logger.note_clob
--MOD PROCEDURE note_non_bind_var - passes i_type TO note_var
--MOD PROCEDURE note_rec_col_var  - passes i_type TO note_var
--MOD PROCEDURE AOP_pu_block - if i_param_types(l_index) = 'CLOB' -  uses ms_logger.param_clob
Modified   database/LOGGER/UnitTest/aop_test.pkb
--Added CLOB tests
Creating a note_rowcount has been discredited and temporarilly removed.

The use of note_rowcount will change SQL%ROWCOUNT, if tested on the next line of code.
Potentially also the insertion of any logger commands between execution of SQL and the testing of SQL%ROWCOUNT
Given this, may be necessary for the AOP_PROCESSOR to created WARNINGS when SQL%ROWCOUNT tests are found in the code,
to ensure the Developer is aware of the issue.

Modified   database/LOGGER/Packages/aop_processor.pkb
--MOD PROCEDURE AOP_block - commented out note_rowcount
Modified   database/LOGGER/UnitTest/aop_test.pkb
Modified   database/LOGGER/UnitTest/aop_test.pks
--NEW FUNCTION test5 - tests for note_rowcount
Modified   apex/f104/application/create_application.sql
Modified   apex/f104/application/pages/page_00008.sql
--NEW Refresh button
Modified   apex/f104/application/pages/page_00009.sql
--MOD Module Type list - add "Apex Block"
Modified   apex/f104/application/set_environment.sql
Modified   database/LOGGER/Packages/ms_logger.pkb
--MOD FUNCTION find_module - IF owner IS 'ANONYMOUS' THEN module_type will be 'APEX'
Modified   database/LOGGER/UnitTest/aop_test.pkb
--FIX call to ms_api.set_module_debug
Minor changes

Modified   apex/f104/application/create_application.sql
Modified   apex/f104/application/pages/page_00008.sql
--Added message_count to Process Report
Modified   apex/f104/application/pages/page_00009.sql
--Changed module_type Apex Block to Apex App.
Modified   database/LOGGER/Packages/ms_api.pkb
NEW Patch: LOG-01_14A_14B_LOGGER - changes

* AOP_PROCESSOR now handles CLOB vars and Params
* Creating a note_rowcount has been discredited and temporarilly removed.
* FIX get_smartlogger_report_URL
Merge branch 'master' of https://github.com/peter-genesys/SmartLogger into feature/logger/LOG-01
Old changes
These changes are old, I'll have to sort out later why they were not good enough to commit.
Merge branch 'feature/logger/LOG-01' into develop