THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
| Panel |
|---|
DAS das = DAS.FACTORY.createDAS(getConnection()); |
...
This example makes use of a configuration file to define the command including the OUT parameter:
| No Format |
|---|
<Config xsi:noNamespaceSchemaLocation="http:///org.apache.tuscany.das.rdb/config.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> |
...
<Command name="getNamedCustomers" SQL=" |
...
{call GETNAMEDCUSTOMERS(?,?)} |
...
" kind="procedure"> |
...
<Parameter direction="IN" columnType="commonj.sdo.String"/> |
...
<Parameter direction="OUT" columnType="commonj.sdo.IntObject"/> |
...
</Command> |
...
</Config> |
This stored procedure is defined such that the first argument provides a name to match when looking for customers and the second argument is an OUT parameter and providing the number of customers that match the provided name. The proc also returns the list of matching Customers.