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

    Bug: Tabular form

    Baki Sine
      Hi

      Application Express 4.2.0.00.27

      I've created tabular form managed by rowid . It' works, but when I changed Application Primary Language to Serbian (sr) , error appears.


      failed to parse SQL query:
      ORA-01741: illegal zero-length identifier

      When form is managed by primary key - no problems

      In same tabular form, when I set default value of field DNAME, Default type (application or page item name),
      In field "Default" I set default_name
      This is application_item. When run form I get meessage :

      failed to parse SQL query:
      ORA-00923: FROM keyword not found where expected

      Same behavior is when for default value instead application item, used page item

      See page 1 on

      [http://apex.oracle.com]

      workspace: WSBUG
      username: passdario@hotmail.com
      password: demo

      application bugs


      thanks !

      Edited by: Baki Sine on Nov 27, 2012 2:17 PM

      Edited by: Baki Sine on Nov 27, 2012 2:18 PM

      Edited by: Baki Sine on Nov 28, 2012 4:47 AM
        • 1. Re: Bug: Tabular form
          Patrick Wolf-Oracle
          Hi Baki,

          is app 57639 page 1 the page to reproduce your problem? What do I have to do in your test app to reproduce the error, because it doesn't contain any enterable tabular form columns?

          Regards
          Patrick
          -----------
          My Blog: http://www.inside-oracle-apex.com
          APEX Plug-Ins: http://apex.oracle.com/plugins
          Twitter: http://www.twitter.com/patrickwolf
          • 2. Re: Bug: Tabular form
            Baki Sine
            Hi Patrick,

            You are rigth, and I am suprised, because error on page 1 disappears. Since login data is published in my previous post for this workspace, someone changed query of tabular form. In fact they removed "ROWID" column from query.
            When I updated query on inital state with "ROWID" column, error is back. Note that column ROWID is generated by wizard of tabular form when managed by ROWID.

            Original query

            select "ROWID",
            "DEPTNO",
            "DEPTNO" DEPTNO_DISPLAY,
            "DNAME",
            "LOC"
            from "#OWNER#"."DEPT"


            Please, change Application Primary Language to English and error is gone :)

            Regards
            • 3. Re: Bug: Tabular form
              Baki Sine
              Hi Patrick

              did you see my previous post ?

              regards
              • 4. Re: Bug: Tabular form
                Patrick Wolf-Oracle
                Hi Baki,

                that's the same issue reported here Re: APEX 4.2 EA - Old bug with "sr" lang still didn't fixed?

                The root cause is a database bug when regexp_replace is used with NLS set to Serbian (bug# 15946905).
                We have worked around the issue and do provide a fix 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