My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.