4 Replies Latest reply: Dec 4, 2012 12:12 PM by Patrick Wolf-Oracle RSS

    APEX 4.2 EA - Old bug with "sr" lang still didn't fixed?

    Bozo
      Since APEX version 4 there's problem with serbian (sr) language as primary app language:

      - Tabular forms don't work (if you want to provide default column value based on page item value),
      - Get Next or Previous Primary Key Value process don't work.

      This things have been described in previous post Re: Master-detail form problem after upgrading to 4.1

      I would kindly ask anyone from dev team to respond on this thread with some comment about this issue?
        • 1. Re: APEX 4.2 EA - Old bug with "sr" lang still didn't fixed?
          bato
          There is the same issue with 4.2 production
          • 2. Re: APEX 4.2 EA - Old bug with "sr" lang still didn't fixed?
            Christian Neumueller-Oracle
            Hi,

            I just had a look at this bug and could isolate the problem to an interesting behaviour of regexp_replace, in combination with the 'i' parameter and CYRILLIC SERBIAN:
            SQL> alter session set nls_language="CYRILLIC SERBIAN";
            
            SQL> with str as (
              2      select 'select to_number(:"P108_ID") "FAK_ID' src,
              3             ':"P108_ID"' search,
              4             ':p1' repl
              5        from dual )
              6  select regexp_replace(src,search,repl,1,0,'i') repl_i,
              7         regexp_replace(src,search,repl,1,0) repl_no_i
              8    from str
              9  /
            
            REPL_I                          REPL_NO_I
            ------------------------------- ------------------------------.
            select to_number:p1") "FAK_ID   select to_number(:p1) "FAK_ID
            Apex has to rewrite the query, to eliminate quoted bind variables. As a workaround, until we can fix the engine, please try to remove the double quotes around the bind variables.

            Regards,
            Christian
            • 3. Re: APEX 4.2 EA - Old bug with "sr" lang still didn't fixed?
              977575
              Hello All,

              Kindly help me out if possible,

              I have a table, lets say table1.

              Kindly guide me that if I want to store a PDF under a column of table1 then how can I store it? What the datatype should I use to store this pdf.

              &

              Also Kindly give me the way to display this PDF through Report...
              Thank you...
              • 4. Re: APEX 4.2 EA - Old bug with "sr" lang still didn't fixed?
                Patrick Wolf-Oracle
                Hi,

                just as follow up. The database bug# is 15946905.

                We have added a workaround into the APEX engine which will be shipped in our upcoming APEX 4.2.1 patch set.

                Regards
                Patrick
                -----------
                My Blog: http://www.inside-oracle-apex.com
                APEX Plug-Ins: http://apex.oracle.com/plugins
                Twitter: http://www.twitter.com/patrickwolf