logger_install script is missing

[eaolson]

Installing Logger for the first time on my own instance. The create_user script says to run the logger_install.sql script as the logger user, but that script doesn't exist in source/install. I found a version in releases/logger_3.1.1.zip. That raised one error when creating a trigger, but recompiling after installation and it seems to be fine.

[p3t3r]

Seeing the same issue, Is this getting fixed? Thanks for the work-around.

[jeffreykemp]

This is a documentation issue. The installation scripts are in the releases folder.

[motey]

Where do i make pull requests for fixes for the logger_install script?

[martindsouza]

I'm in the process of rebuilding the entire install process. What changes do you want to make?

I know it's not github best practices but it may be best right now to highight the code change in this ticket.

[motey]

I had an issue when trying to install logger from a sqlplus script to a certain schema. in this script i changed the current schema with alter session set current_schema = WHATEVERUSER before calling the install_logger script. In this case query in line 112 for examples fails

select nullable
    into l_nullable
    from user_tab_columns
    where table_name = 'LOGGER_LOGS'
      and column_name = upper(l_required_columns(i));

Because with alter session set current_schema only the working schemas changes but not the user context. I had to change the query to

select nullable
    into l_nullable
    from dba_tab_columns
    where table_name = 'LOGGER_LOGS'
	  and owner = sys_context('userenv','current_schema')
      and column_name = upper(l_required_columns(i));

same for queries in lines

• 139
• 158
• 176
• 197
• 221
• 395
• 426
• 480
• 514
• 539
• 557
• 595
• 649
• 669