SQL*Developer 4.0.2 Fails to Convert Sybase Stored Procedures Correctly or Gives Errors (Doc ID 1921704.1)

Last updated on JANUARY 19, 2017

Applies to:

Oracle SQL Developer - Version 4.0 and later
Information in this document applies to any platform.

Goal

Migrating Sybase procedures using SQL*Developer 4.0.2 the conversion is not correct or can give various errors.

For example -

 

1. The Sybase procedure -

create proc FillPemission          
@code_dsi varchar (4000), MANDATORY
@tb varchar (50) = null     OPTIONAL

 
is converted with the wrong datatype -
 

     

CREATE OR REPLACE PROCEDURE FillPemission            
(                                                    
 iv_code_dsi IN VARCHAR2 DEFAULT NULL ,     OPTIONAL
 v_tb IN VARCHAR2 DEFAULT NULL ,            OPTIONAL
 cv_1 OUT SYS_REFCURSOR      

       

2. The following error is given during conversion -

 

<message>Failed To Convert Stored Procedure fps_bond antlr.NoViableAltException>gia.dbo.ibp_fps_bond:unexpected end of subtree:Line 0 Column 0:
[gia.dbo.fps_bond [ line 5:5: unexpected token: SELECT ],gia.dbo.fps_bond [ line 5:5: unexpected token: SELECT ],gia.dbo.fps_bond [ line 12:44: expecting "end", found ')' ]]</message>

   
3. This error can also happen -

 

<record>
<date>2014-08-21T11:47:20</date>
<logger>oracle.dbtools.migration.workbench.core.MigrationLogResourceBundle</logger>
<level>SEVERE</level>
<class>oracle.dbtools.migration.convert.ConverterWorker</class>
<message>Failed To Convert Stored Procedure il_composition java.lang.StringIndexOutOfBoundsException>gia.dbo.il_composition:String index out of range: 0::
[]</message>
<param>rpt_il_composition, MD_STORED_PROGRAMS, 106198801Convert</param>

</record>


 4. Outer joins in the Sybase procedure are not correctly converted.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms