My Oracle Support Banner

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

Last updated on JUNE 08, 2023

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

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.