Error Creating Stored Procedure w/Signature

, ,
1

Hi,

A few week back the IS started to show the following error when creating an Adapter service - Stored Procedure With Signature.

com.wm.app.b2b.server.ServiceException: [ART.114.243] Adapter Runtime (Metadata): Failed to run resourceDomainLookupValues service. Details provided in error log.
[ADA.1.320] Cannot get the list of stored procedures. "
(17412) Bigger type length than Maximum"
Bigger type length than Maximum
on procedureSignature.colIndexes [Ljava.lang.String;@170376


Note that I’m able to select the Procedure Name in the combo box, but once selected the error is display.

Thanks.
Francisco Pereira

Any ideas why?

2

What version of the JDBC adapter is this? Do you have latest version of the JDBC drivers installed?

3

I change my driver to ojdbc14.jar and ocrs12.zip, and it started working correctly.

Those are the jars recommended for my Oracle DB Version.

Thanks