APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to adjust Interactive Grid in edit mode and force nls_numeric_characters ?

Frantisek MikaJul 23 2018 — edited Jul 23 2018

For some reason we switch nls settings in our apex application ( EXECUTE IMMEDIATE 'alter session set nls_numeric_characters = '',.'' '; ). For Interactive Grid it works fine in view mode - decimal places are separated by comma even if the user works in English(en) settings.

The problem occurs after the user edit the number with decimal places. When user save such a number, Interactive Grid did not raise any error, but dismiss the decimal point (Comma) and save the number incorretly (by example: user enter 125,363 value and IG save it as 125363 value).

Is this IG behaviour deliberate or is it a bug? Can anybody advice how to fix this problem?

This post has been answered by Frantisek Mika on Jul 23 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 20 2018

Added on Jul 23 2018

#apex-discussions

9 comments

844 views