Re: JDBC CallableStatement, plain Program Call, and output parameters...

James Perkins skrev den 26-08-2008 20:25:

Thorbjørn,
It looks like Coy already told you how to create the stored procedure.

Now for the CallableStatemen. Did you register the parameters,
cs.setObject(parameterIndex, value) ? You will also need to register the out

Thanks for the responses. I'll look into the stored procedure creation tomorrow.

I did when I experimented with the "raw" program call, but it failed as previously mentioned when it tried to locate what to call - I did not get to the binding of values to the ?-placeholders.

Hopefully this will work easily, and this is the sole one we can call, so I do hopefully not need your factory. But never say never :) Thanks for offering!

I like the many ways of doing things on the i - it is nice to have something to choose between in a given scenario.