Unable to invoke a procedure with no input and output arguments using Teradata Adapter' RPC service.

Unable to invoke a procedure with no input and output arguments using Teradata Adapter' RPC service.

book

Article ID: KB0087032

calendar_today

Updated On:

Products Versions
TIBCO Adapter for Teradata -
Not Applicable -

Description

Description:
Symptoms
========
The adapter throws the following error when a RPC invocation of this type is attempted.

TeradataAdapterConfiguration.TeradataAdapterConfiguration Error [Database] AETD-
000005 SQL Error - Syntax error: expected something between the word 'AddToTable' and ';'.  


Impact
======

Loss of Functionality

The Stored Procedure invocation fails.

Workaround
==========

The procedure name needs to be edited in the dat file.

Suppose  Test is the database and AddToTable is the procedure with no input arguments, then there is an entry in the dat file say  'call Test.AddToTable' . This needs to be changed to 'call Test.AddToTable;' [semicolon to be added at the end of proc name].


Cause
=====
This is a defect with the Teradata Adapter 5.1.0.
A semi-colon is missing from the procedure name in the dat file.

Resolution
========
This issue will be addressed in a future release\hotfix .
Symptoms:

Cause:

Issue/Introduction

Unable to invoke a procedure with no input and output arguments using Teradata Adapter' RPC service.