Sybase Procedures Not Converted and Give Error antlr.NoViableAltException If Holdlock or Noholdlock Used in Procedure (Doc ID 1928602.1)

Last updated on JANUARY 09, 2017

Applies to:

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

Symptoms

Miigrating from Sybase 12 to Oracle using SQL*Developer v4.0.2 or v4.0.3 some Sybase procedures
give the error -

Failed To Convert Stored Procedure sp_ReasignaEmpresas
antlr.NoViableAltException>SOFIA.dbo.sp_ReasignaEmpresas:unexpected end of
subtree:Line 0 Column 0: [SOFIA.dbo.sp_ReasignaEmpresas [ line 70:31:
unexpected token: G ]]


or -

antlr.NoViableAltException>SOFIA.dbo.null:unexpected end of subtree:Line 0
Column 0:
  [SOFIA.dbo.null [ line 28:8: unexpected token: PERFIL_USO ],SOFIA.dbo.null
[ line 31:5: unexpected token: UPDATE ]]

 

Cause

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