Forum Stats

  • 3,814,896 Users
  • 2,258,927 Discussions
  • 7,892,883 Comments

Discussions

Search on Interactive Grid with accent insensitive

Gerard Otin
Gerard Otin Member Posts: 16 Blue Ribbon

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!

Tagged:

Best Answer

  • Gerard Otin
    Gerard Otin Member Posts: 16 Blue Ribbon
    Answer ✓

    Update:

    Setting the Character Value Comparison Behavior to “Linguistic” (in Application Proprties > Globalization) solves this.

    Even though in the help text does not mention IG, it works as well.

    Regards,

Answers

  • Gerard Otin
    Gerard Otin Member Posts: 16 Blue Ribbon
    Answer ✓

    Update:

    Setting the Character Value Comparison Behavior to “Linguistic” (in Application Proprties > Globalization) solves this.

    Even though in the help text does not mention IG, it works as well.

    Regards,