This discussion is archived
4 Replies Latest reply: Dec 4, 2012 10:12 AM by Patrick Wolf RSS

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

Bozo Newbie
Currently Being Moderated
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?
    433937 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points