1 Reply Latest reply on Feb 21, 2014 1:39 PM by thatJeffSmith-Oracle

    Convertion of text from german to english

    sank_nk

      Hi All,

       

      I am looking for a pluggin or a tool that will convert the pl/sql code (Multi line and one line Comments) written in german to english. I am not sure if there is plugin available for sql developer which will automatically do so.

       

      Example:

      /**

            Ermitteln Briefanrede (inkl Titel- und Kundenbezeichnung)

            ==========================================================================

            Funktion zur Ermittlung der Briefanrede inklusive Titel- und

            Kundenbezeichnung (max Char 35)

            ==========================================================================

            P_KdLnr     =>

            P_SpracheCd =>

            return      =>

         */

         function F_GetBriefanrede (P_KdLnr      in number,

                                    P_SpracheCd  KD_STAMM.SPRACHE_CD%type)

                                    return varchar2 is

      Line1||chr(10)||L_Address_Line2),1,160);

           ..............

           .......................

           ..............
          exception

             when others then

                SRQUTIL0.Mess( 'KDQUTIL0', 'GetBriefanrede', 'GLERR', -9800, 'Keine gültige Briefanrede gefunden für KD_LNR= '||P_KdLNr, 'FE', SRQUTIL0.V_LastLogLnr, '', SRQUTIL0.V_LastMsgStr);

                L_Return := '1010';

                return(L_Return);

        end F_GetBriefanrede

       

      SHOULD BE CONVERTED AS:

      /**

            Determine form of address (including title and client name)

          ==========================================================================

          Function to determine the form of address including the title and

          Customer name (max 35 char)

             ==========================================================================

            P_KdLnr     =>

            P_SpracheCd =>

            return      =>

         */

         function F_GetBriefanrede (P_KdLnr      in number,

                                    P_SpracheCd  KD_STAMM.SPRACHE_CD%type)

                                    return varchar2 is

       

         L_Address_Line1  varchar2(80);

      .................

      ..............

      .............................

      exception

             when others then

                SRQUTIL0.Mess( 'KDQUTIL0', 'GetBriefanrede', 'GLERR', -9800, 'Keine gültige Briefanrede gefunden für KD_LNR= '||P_KdLNr, 'FE', SRQUTIL0.V_LastLogLnr, '', SRQUTIL0.V_LastMsgStr);

                L_Return := '1010';

                return(L_Return);

        end F_GetBriefanrede;

       

      I have tried google translate and unfortunately it adds/removes few semi-colon, commas etc.

       

      Please let me know if there is pluggin available for sql developer or toad which will help me convert the german text to english.