Hi all,
Client wants to search on IG ignoring accents. For example, if there's a row that contains "ALCALÁ", he wants that when he search "ALCALA", this row appears in the results.
I've tried executing this in Security -> Inizialization PL/SQL code:
execute immediate 'ALTER SESSION SET NLS_SORT=BINARY_AI';
execute immediate 'ALTER SESSION SET NLS_COMP=LINGUISTIC';
But APEX pages won't load (blank), and debug shows error ORA-06502: PL/SQL: numeric or value error: associative array shape is not consistent with session parameters :
Backtrace: ORA-06512: en "APEX_190200.WWV_FLOW_PLUGIN", línea 447
ORA-06512: en "APEX_190200.WWV_FLOW_PLUGIN", línea 1634
ORA-06512: en "APEX_190200.WWV_FLOW_PAGE", línea 2518
ORA-06512: en "APEX_190200.WWV_FLOW_PAGE", línea 2758
ORA-06512: en "APEX_190200.WWV_FLOW", línea 4838
It seems like this error is because the NLS parameters on DB are different from the session, but I think changing this parameters at DB level is not an option, and I don't know what else can I look for.
APEX version 19.2.
Any ideas?
Thanks!