any DML fails when session is not connected to Web PL/SQL Gateway

connormcd / audit_utility

Automatic generator for the typical audit triggers we have on Oracle tables with lots of options

51 stars 20 forks source link

any DML fails when session is not connected to Web PL/SQL Gateway #11

Closed akluev closed 1 year ago

akluev commented 1 year ago

because of this line

    l_headers(l_idx).host := coalesce(owa_util.get_cgi_env('X-Forwarded-For'), owa_util.get_cgi_env('REMOTE_ADDR'), sys_context('userenv','host'));

akluev commented 1 year ago

update ohrr_data.config_variables
set variable_value='25-may-2025'
where variable_key='G_GO_LIVE_DATE'
Error report -
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.OWA_UTIL", line 359
ORA-06512: at "AUD_UTIL.AUDIT_PKG", line 43
ORA-06512: at "AUD_UTIL.AUD$CONFIG_VARIABLES_OHRR_DATA", line 33
ORA-04088: error during execution of trigger 'AUD_UTIL.AUD$CONFIG_VARIABLES_OHRR_DATA'