Error ORA-06550: line 1, Column 13: PLS-00114: Identifier Too Long While Calling a SQLServer Stored Procedure Using DG4MSQL (Doc ID 1593489.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Database Gateway for SQL Server - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

While trying to execute a Microsoft Sql*Server stored procedure from Oracle using the Database Gateway for SQL*Server (DG4MSQL) the following error is returned -

EXEC "dbo"."spUpdateDailyInventoryDeliveryQty"@TEST_DGSQL('62761',SYSDATE);

ORA-06550: line 1, column 13: PLS-00114: identifier 'spUpdateDailyInventoryDelivery' too long.

The procedure "spUpdateDailyInventoryDeliveryQty" is located in Sql*Server and accessing this procedure over a database link from Oracle server gives the error.



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