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](https://forums.oracle.com/ords/apexds/user/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 -
Can you help here please?
Thanks,
Vikram R