on 05-16-2007 4:20 AM
Hi all
Am new to Stored Procedures. I need to do an HTTP-JDBC scenario using SP(synchronous). My SP takes an output parameter 'flag' (along with the input parameters)and sets it to 0 or 1 depending on a condn. I need to get this value at my HTTP client. Could you please tell me what should be the structure of my SP response message and how should be the mapping done?
Thanks
Chilanka
Hi,
The request message should look like,
<root>
<CallOracleProc>
<storedProcedureName action>
<table>
<input element isInput type/>
<outputElement isOutput type/>
</table>
</storedProcedureName>
<CallOracleProc>
</root>
Response should be,
<root_response>
<CallOracleProc_response>
<OutputElement/>
</CallOracleProc_response>
</root_response>
Regards
Bhavesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Bhavesh,
I have tried this. but in my response message, am getting one more complex element: <response_1>
<update_count>1</update_count>
</response_1>
Even that's fine; but I need to do some processing on the SP response. When I include the response message in a message mapping, it throws exception at runtime. Is it not possible to perform processing on the response? if , how? Please do reply
Thanks
Chilanka
Hi-
Check these links may be helpful to you....
/people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter
/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.