JDBC Adapter 46 Stored procedure call

Does anyone have an example of what the stored procedure should look like when called from the JDBC Adapter 4.6 (Enterprise Server 5.0)

I haven’t been able to find any documentation on this. I’ve found it for the Oracle Adapter, but not the JDBC Adapter!

Whenever I try to call my stored procedure, I always get an error that says the wrong number or type of parameters is being passed.

Thanks in advance for any help!

Hi Kevin,

At the time we had a similar integration, we were using the JDBC Adapter to connect to an AS/400. But there was a bug with the JDBC Stored Procedure Call Operation. So instead, we configured a Scripted Operation with a custom step. In the custom step, we used java code to call the SP.

Unfortunately, I don’t have a copy of the actual SP. But if you want to know more about the java calls we used, let me know.