Error Creating Stored Procedure w/Signature


A few week back the IS started to show the following error when creating an Adapter service - Stored Procedure With Signature. [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.

Francisco Pereira

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, and it started working correctly.

Those are the jars recommended for my Oracle DB Version.