1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Change of Decimal separator

Discussion in 'Oracle Application Express (APEX)' started by IdzoB, Mar 5, 2013.

  1. IdzoB

    IdzoB Guest

    Hi,
    I am new to APEX.I buld my first app but my user want to enter numbers with ',' as decimal separator.
    Creating process before header in master detail form doesn;t help me.
    BEGIN
    EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_NUMERIC_CHARACTERS = ",."';
    END;
    When I try to enter 23,45 value in database column is 2345.
    I do the same thing with sql*plus and I can insert numeric value as:
    INSERT INTO table VALUES ('23,45',.......);
    Text field in master detail tabular form onlu accpet numeric values.
    Thanks!!!:confused:
     
  2. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    Are you applying a Format Mask to the item field?