4 Replies Latest reply: Jan 9, 2013 11:25 AM by 983342 RSS

    How to move data from Database Table to Dynamic Translation Repository

    977656
      Hi,

      I have a requirement where Instead of creating each entry in Dynamic Translation Repository manually for every word and for each language,

      if I can move the data directly from my database table to this repository?

      In database table, same three columns will be there "Translation from", "language" and "Translation to"

      is there a way of doing this.

      Apex 4.1.0.00.32
      Oracle 11g R2

      Regards,
      Ani
        • 1. Re: How to move data from Database Table to Dynamic Translation Repository
          Arie Geller
          Hello Ani,

          >> I have a requirement where Instead of creating each entry in Dynamic Translation Repository manually for every word and for each language, if I can move the data directly from my database table to this repository?

          The API for dynamic translation is not documented, hence it is NOT supported by Oracle.

          Having said that, you can export an application that includes a dynamic translation entry and learn how APEX creates this repository. Hint - look for
          wwv_flow_api.create_dynamic_translation
          Now you can use this API in your own script.

          Regards,
          Arie.


          -------------------------------------------------------
          ♦ Please remember to mark appropriate posts as correct/helpful. For the long run, it will benefit us all.

          ♦ Author of Oracle Application Express 3.2 – The Essentials and More
          • 2. Re: How to move data from Database Table to Dynamic Translation Repository
            977656
            Hi Arie,

            Thanks for the quick reply.

            when I am trying to export my application with "Export Translations" I am getting error:
            Error     Error exporting flow 802. ORA-06502: PL/SQL: numeric or value error: character string buffer too small
                      ORA-06502: PL/SQL: numeric or value error: character string buffer too small
            but when I am exporting without Export Translations it is exporting.

            Regards,
            Ani
            • 3. Re: How to move data from Database Table to Dynamic Translation Repository
              Arie Geller
              Hello Ani,

              >
              when I am trying to export my application with "Export Translations" I am getting error:
              Error     Error exporting flow 802. ORA-06502: PL/SQL: numeric or value error: character string buffer too small
                        ORA-06502: PL/SQL: numeric or value error: character string buffer too small
              We need some more information about your environment like database version and characterset, APEX version and Web connection (OHS with plsql_mod, EPG or APEX Listener). Also, in what languages are you working?

              BTW, the dynamic translation messages are included in any application export, regardless of the setting for Export Translations.

              Regards,
              Arie.
              • 4. Re: How to move data from Database Table to Dynamic Translation Repository
                983342
                Hi Arie,

                Thanks, This helped me resolving the issue.

                Sorry, I can't mark your post as correct, I changed my email id and it delinked my old messages and posts.

                having few more questions, creating new post for that.

                Thanks again.

                Regards,
                Ani