MQSeries.net :: View topic - calling oracle stored procedure by using JDBC Adapter:

mqseries0209

Hi,

I am trying to configure an JDBC adapter to execute two stored procedures depending on incoming verb and this should by achieved by using a single wrapper BO.

One SP execution results in a Result Set (achieved by using RetrieveSP)and other is simple update (by using UpdateSP).

Here is how BO looks like:

<Main BO>
<Att1>
<Att2>
<Att3>
<ChildBO1> // This BO is used to execute SP for Retrieve
<RetrieveSP>
<Att_1>
<Att_2>
</ChildBO1>
<ChildBO2> // This BO is used for Update
<UpdateSP>
<Att_1>
<Att_3>
</ChildBO2>
</Main BO>

Well My Question is it possible to execute two different SP's independently based on incoming verb (Retrieve for RetrieveSP and Update for UpdateSP), by using the above wrapperBO ?

Any help is appreciated.