an example stored procedure invocation

[london_coder]

Hi,

Just dowmnoaded orbroker, and it looks good. But, would it be possible
to provide a simple example of invoking a stored procedure, with IN
and OUT paramerers please?

Sorry if this is a dumb request.

[Nils Kilden-Pedersen]

I don't have much time right now, but there are two examples in the TestBroker file, testSP, which uses the callForParms method to receive an OutParms callback, and testSP2, which defines an OutParm extractor to use with selectOne method.

Let me know if that's sufficient, and if not, I'll try to help further.

Nils

[london_coder]

Nils,


Mant thanks, that is exactly what I needed. Also, thank you for the
impressively quick response :)

Regards
Alan

On Oct 11, 2:26 pm, Nils Kilden-Pedersen <nil...@gmail.com> wrote:
> I don't have much time right now, but there are two examples in the
> TestBroker file,

> testSP<http://code.google.com/p/orbroker/source/browse/src/test/scala/test/o...>,

> which uses the callForParms method to receive an OutParms callback, and

> testSP2<http://code.google.com/p/orbroker/source/browse/src/test/scala/test/o...>,

[Nils]

Stored procedure usage may or may not work easily, depending on which RDBMS and JDBC driver you're using. E.g. the jTDS driver has this bug that prevents it from being used without some manual workarounds.