Skip to Main Content

Search on Interactive Grid with accent insensitive

Gerard OtinFeb 9 2021

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!

This post has been answered by Gerard Otin on Feb 9 2021
Jump to Answer
Comments
Post Details
Added on Feb 9 2021
1 comment
34 views