5 Replies Latest reply on Aug 11, 2018 2:21 PM by vikramrathour

    Scratch Editor - SQL Developer (Version 17.4.1.054) - Identifier name truncated

    vikramrathour

      Hello,

      I am using SQL Developer to Migrate Sybase 15.7 to Oracle 12c. When I translate a SP using scratch editor the identifier names which are > 30 chars in size are truncated.

      Source Sybase Code -

      create PROCEDURE hierarchy_to_variable 
      (
          @customer_type_hierarchy_type        general_code     = NULL
      ,   @initiating_office_hierarchy_type    general_code     = NULL         --OFFICE , MROFFICE, OFFICEBE
      ,   @initiating_office_base_entity_code  general_code     = NULL  OUTPUT 
      )
      AS
      BEGIN
      
      
      IF (@initiating_office_hierarchy_type IS NOT NULL)
      BEGIN
      print 'Hello'
      END
      
      
      END
      ;
      

       

      target PL/SQL generated by scratch editor -

      CREATE OR REPLACE PROCEDURE hierarchy_to_variable
      (
        customer_type_hierarchy_type IN UDT.GENERAL_CODE%TYPE DEFAULT NULL ,
        initiating_office_hierarchy_ty IN UDT.GENERAL_CODE%TYPE DEFAULT NULL ,--OFFICE , MROFFICE, OFFICEBE
        initiating_office_base_entity_ IN OUT UDT.GENERAL_CODE%TYPE/* DEFAULT NULL*/
      )
      AS
      
      
      BEGIN
      
      
         IF ( initiating_office_hierarchy_ty IS NOT NULL ) THEN
          
         BEGIN
            DBMS_OUTPUT.PUT_LINE('Hello');
         
         END;
         END IF;
      
      
      EXCEPTION WHEN OTHERS THEN utils.handleerror(SQLCODE,SQLERRM);
      END;
      

      i have set all the right options in the preferences -

      Migration_pref1.PNG

      Migration_pref2.PNG

      Migration_pref3.PNG

       

      Can you help here please?

       

      Thanks,

      Vikram R