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.
Any ideas why?
What version of the JDBC adapter is this? Do you have latest version of the JDBC drivers installed?
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.